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 these users to refresh the data. Coming with version 1.1.0, Power BI Sidetools exports your data into Excel with only one click. Then you can setup pivot tables, add theme…
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 some time when we do it for the first time. But we expect the maintenance of translations will be as easy as possible when the report will be modified or…
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 used visual labels are titles so I will focus on this kind of label in this post. Steps to translate visuals titles Create a table with the translations including an…
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 in M language. The username might be useful to filter a table or to get a file path in the ‘Documents’ folder. The following post describes 4 ways to get…
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 date range in the tooltip Edit the ‘Selected filters’ measure and add a new variable (Filtered_date) You may adapt the date format to your needs. From now on, the…
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…
