In case you cannot make Power BI assistant work, you may use Power BI assistant troubleshooting to solve common issues. Please apply fixes in this order. Open only ‘Power BI assistant’ report and make it work with itself If you get some issue, don’t open any other Power BI report. Power BI assistant may analyse…
In Power BI service, you can print a data matrix as an ID of your report. Stick data matrix anywhere and get insights on your phone from data matrix sticker within Power BI phone application. Publish your report to the service Open your report on Power BI service Click on the three dots at the…
Imagine to view reports in your glasses and control them with your hands. Use augmented reality with your Power-BI reports. This might seem to be sci fi but it’s already on the shelf. Augmented reality in maintenance Augmented reality in industry Augmented reality in airport For more augmented reality with Power-BI reports, see also :…
You can add data in a table or in an Excel file from your reports. Additionally, you can include a small application. The way to achieve these goals is to add a PowerApps visual. So, please watch this 4 minutes video to add data in a table from your reports. https://www.youtube.com/watch?v=3eiUR8Lo4i4&feature=youtu.be For more interactions from…
Dynamic links are urls including some ID. So by clicking on these links, the user is redirected to any web page and take actions within this page. The security is assured by the website. I strongly recommend to create dynamic links in your tables. How to Open a new report and open Power Query Create…
Do you want to check the features which will be developped during the next months ? Please read the Power platform roadmap. Check and vote for ideas supporting these evolutions. How to check the Power platform roadmap Click on the link down below and select the latest roadmap. The document is huge as it covers…
Often, we need to look for a table or for a specific column in the database. Do you know it’s possible to create a simple query to visualize your database schema within Power Query ? Very few steps for great results. How to display database schema (first method with data preview) Add a blank query…
Export Power-BI desktop data to Excel with R. This R script exports a Power BI table automatically to an Excel (xlsx) file. This works from your report with an ‘Export’ button. The maximum number of exported lines is 150 000. How to export Power-BI desktop data to Excel Install R and R studio. Please have…
Once you know your report is filtered having a look at the green light, you expect to get more details. So add a tooltip to display applied filters. How to add a tooltip to display applied filters Create a tooltip page, name it ‘TT filters’ and hide this page. See this blog post if you…
To understand properly our data, the very first thing we need to do is to perfectly know the filters applied to data. There are many ways to filter data (in the data source, in Power Query, in report/page/visual filters, slicers, …). So if you don’t understand your filters, you don’t understand your data. I will…
