The BI Power provides services about Microsoft Power BI (Power BI desktop, Power Query, …). Please have a look at our blog posts to get some amazing content about these wonderful tools.
Power BI Sidetools
Power BI desktop
Power Query
The BI Power blog posts :
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…
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…
A really efficient way to get immediately more insights is to use a tooltip page in your report. I consider it is a good practice…
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…
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…
Automatic translation of visuals labels in Power BI reports is possible using conditional formating, Tabular Editor and an Excel template. At the moment, labels are…
I encountered some problems to get Power BI map visual working properly. So I share here the way I do using few tips for map…
Automatic translation of tabular model using Tabular Editor and Excel is possible since the Power BI team gave read/write access to the XMLA endpoint. For…
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…
Text and file search in Visual Studio Code is really powerful. There are different ways to search and replace. The only difficulty you will meet…
While working in Power BI desktop, we often need to export to Excel some data sharing with customers or colleagues. Once shared, we don’t want…
Compare DAX and M formulas in Visual Studio Code is really easy with the help of Power BI Sidetools.As it is possible to transfer DAX…
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…
Do you want to check the features which will be developped during the next months ? Please read the Power platform roadmap. Check and vote…
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…
When we use a report, it’s important to know if users applied filters. So, you can display a light when data is filtered. How to…
Translations life cycle management must be considered seriously as soon as we decide to translate Power BI reports. Translating a report in several languages takes…
Don’t forget to add your filtered date range in the tooltip. This is one of the most important filter to display. How to add your…
Final users need to know when the report has been refreshed for the last time. Here is my way to do it. I simply add…
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…
Visuals labels translations in Power BI reports are not supported natively. However, there is a trick using conditional formating which does the job. The most…
Sometimes, it is useful to compare the same data from two columns. So, here is a simple function to do it in Power Query. The…
Since the Power BI team allowed to launch external tools from the Power BI desktop ribbon, several tools became available. Do you know you can…
Get username function in Power Query with few lines of M code. For the moment, there is no native way to get the Windows username…
There are different ways to filter data in Power BI reports. My favorite one is to create a specific filter page containing many slicers. These…
It’s sometimes useful to compare visuals functionalities. This report is only made for that : compare similar visuals with the Visuals test report. Download the…
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…
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…
As duplicates are a nightmare in databases, I wrote a function to identify them between two tables. Duplicates detection in Power Query is extremely useful…
DAX debugger is meant to help Power BI report developers displaying sample data from a DAX formula. Measures, calculated columns and calculated tables can be…