Reference Power BI theme colors in DAX

Did you know that you can refer to the Divergent colors of the theme in DAX?  😱
Maybe I’ve seen it somewhere, but I can’t remember and it’s hard to find information about it on the internet.

Reference Power BI theme colors in DAX weiterlesen

How to use multiple Power BI Desktop profiles

Those who work in several Power BI tenants surely know the problem. For each tenant, you have to sign out and sign in again in the Power BI Desktop. If the same connectors, such as the Business Central connector, are used, the logon data must also be changed each time. How cool would it be if you could start Power BI Desktop with different profiles, which brings me to my little batch script idea.

How to use multiple Power BI Desktop profiles weiterlesen

Calculate ISO 8601 Calendar Week in Power Query with SQL Query Folding

If you search the internet for a calculation of the ISO calendar week in Power Query, you will often find a Custom Function that does the job. But unfortunately the Custom Function interrupts the query folding for SQL data sources, which mostly slows down the loading process. In this post I provide a solution that also supports query folding for SQL data sources.

Calculate ISO 8601 Calendar Week in Power Query with SQL Query Folding weiterlesen

Power BI – UK User Group: Exploring the Power BI Datamarts

On 18.08.2022 I was a guest speaker at the Power BI – UK User Group. There we explored the new Power BI Datamarts together. If you missed the event, you can find the recording here. Have fun watching it.

Power BI – UK User Group: Exploring the Power BI Datamarts weiterlesen

Manchester Power BI User Group: Exploring the Power BI Datamarts

On 28.07.2022 I was a guest speaker at the Manchester Power BI User Group. There we explored the new Power BI Datamarts together. If you missed the event, you can find the recording here. Have fun watching it.

Manchester Power BI User Group: Exploring the Power BI Datamarts weiterlesen

Copy Power BI data model back to PBIX file

Do you know this message? “This file can’t be downloaded yet. You can’t download this file right now because it’s been modified using an XMLA endpoint.” How to copy the Power BI data model back to a PBIX file anyway, I describe in this post.

Copy Power BI data model back to PBIX file weiterlesen

Display images from Business Central in Power BI

This week a colleague asked me if images from Business Central (formerly Dynamics NAV) could also be displayed in a Power BI report and the good news up front, “It works!”

Display images from Business Central in Power BI weiterlesen

Missing (hidden) reports in Power BI service

I was shocked, suddenly important reports were missing from my workspace in Power BI service. But thanks to the help of Mellisa Coates, I was able to make the hidden reports visible again.

Missing (hidden) reports in Power BI service weiterlesen

Export Power BI Desktop Data Preparation to Dataflow

Over the last few weeks we have been working on a Dataflow extension for our Power BI templates. The idea is to extract the existing queries from the Power BI Desktop and provide them as centrally prepared data in a Dataflow. During our development, I developed a small PowerShell script that I have now released on GitHub.

Export Power BI Desktop Data Preparation to Dataflow weiterlesen

Archive Power BI Reports with Power Automate

I recently had the requirement to save the monthly Dataset of a Power BI Report. I remembered a blog post by Chris Webb on how to use Power Automate to access the Power BI Rest API. The following post describes how I use this to create a monthly PBIX backup.

Archive Power BI Reports with Power Automate weiterlesen