Actions within reports

Add data in a table from your reports

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…

Export data | R

Export Power-BI desktop data to Excel

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…

Report filters

3. Display filters applied to data

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…

Power Query

M functions documentation within Power Query

Often we look for the documentation of a function or we even look for a function. We may use Microsoft documentation (https://docs.microsoft.com/fr-fr/power-query/). But there is an other way much more comfortable for my needs: access to M functions documentation within Power Query How to Add a blank query and name it ‘Shared’ Open the advanced…