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 :
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 …
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 …
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 …
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 …
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 …
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. …
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 …
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 filtered …
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 …
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 …
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 …
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 report …
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 …
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 …
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 …
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 …
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 …
A really efficient way to get immediately more insights is to use a tooltip page in your report. I consider it is a good …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
Do you want to check the features which will be developped during the next months ? Please read the Power platform roadmap. Check and vote …
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 …
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 …
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 …