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 weiterlesenKategorie: English Posts
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 weiterlesenPower 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 weiterlesenManchester 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 weiterlesenCopy 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 weiterlesenDisplay 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 weiterlesenMissing (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 weiterlesenExport 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 weiterlesenArchive 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 weiterlesenSeamless 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