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

Seamless integration of Power BI in Business Central

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.

Seamless integration of Power BI in Business Central weiterlesen