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. Today my colleague Ulrik and I were optimizing a demo and asked ourselves whether we could use a DAX measure to … Reference Power BI theme colors in DAX weiterlesen Der Beitrag Reference Power BI theme colors in DAX erschien zuerst auf thinkBI ..read more

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 … Calculate ISO 8601 Calendar Week in Power Query with SQL Query Folding weiterlesen Der Beitrag Calculate ISO 8601 Calendar Week in Power Query with SQL Query Folding erschien zuerst auf thinkBI ..read more

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. With Datamarts, Microsoft offers a new building block in the self-service Power BI stack, but what … Power BI – UK User Group: Exploring the Power BI Datamarts weiterlesen Der Beitrag Power BI – UK User Group: Exploring the Power BI Datamarts erschien zuerst auf thinkBI ..read more

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. With Datamarts, Microsoft offers a new building block in the self-service Power BI stack, but what can … Manchester Power BI User Group: Exploring the Power BI Datamarts weiterlesen Der Beitrag Manchester Power BI User Group: Exploring the Power BI Datamarts erschien zuerst auf thinkBI ..read more

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. NOTE: The workaround described here is not officially supported by … Copy Power BI data model back to PBIX file weiterlesen Der Beitrag Copy Power BI data model back to PBIX file erschien zuerst auf thinkBI ..read more

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!” The special challenge here is that Business Central stores the image compressed with additional 4 bytes in a Blob data type (Binary Large Object) … Display images from Business Central in Power BI weiterlesen Der Beitrag Display images from Business Central in Power BI erschien zuerst auf thinkBI ..read more

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. The whole thing is due to a very (very) un-intuitive behavior in the Power BI service. But let’s start from the beginning … Missing (hidden) reports in Power BI service weiterlesen Der Beitrag Missing (hidden) reports in Power BI service erschien zuerst auf thinkBI ..read more

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 … Export Power BI Desktop Data Preparation to Dataflow weiterlesen Der Beitrag Export Power BI Desktop Data Preparation to Dataflow erschien zuerst auf thinkBI ..read more

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. Register an app for the … Archive Power BI Reports with Power Automate weiterlesen Der Beitrag Archive Power BI Reports with Power Automate erschien zuerst auf thinkBI ..read more

As a business intelligence developer at KUMAVISION AG, one of the world’s largest implementation partners for Microsoft Dynamics, I am so excited about the seamless integration of Power Bi in Dynamics 365 Business Central. You can simply use the Power BI Business Central Connector to load your business data into Power BI and create impressive reports from it. … Seamless integration of Power BI in Business Central weiterlesen Der Beitrag Seamless integration of Power BI in Business Central erschien zuerst auf thinkBI ..read more