Download any Power BI Report from the Power BI Service
I am sure we have all had it where there is Power BI report in the service which has been working for a long time. Then there is a requirement to make a change, and NO ONE can find the original PBIX. There now is an easy way to download the Power BI Report or the Power BI Semantic model…
Running a Power BI Performance load test using Visual Studio Code
This is the final part of my blog series for Power BI Performance testing, where I will finally run the Power BI Performance Load testing using Visual Studio Code. In this blog post I will show you how I set up the test, run the test and view the outputs from the performance testing. Previous Blog posts: Why should I…
Updating the PBIReport.JSON file with the Power BI Performance load testing Values
In the 3rd part of my blog series on Power BI Performance testing, we are now going to take all the values we complete in the previous blog post and update the PBIReport.JSON file. The reason I did this in a separate blog post is because working with JSON files can be tricky and adding to that putting in GUIDS…
How to get the details for Power BI Performance load testing
When completing the Power BI performance load testing, you will need to get details from your Power BI report and App Workspace, which will later be used in the PBIReport.JSON file. In this blog post I will show you how to find those details, so that when it comes time to add it to the PBIReport.JSON file, it will be…
How to Rebind a Power BI Report to a different Semantic Model using Power BI Studio
The default option to rebind a Power BI report is to use the Power BI REST API. This works well, but for a lot of people this can be quite intimidating. Fortunately, Gerhard Brueckl, has created the amazing Power BI Studio, which is a Visual Studio Code Extension. Installing Power BI Studio You can download it here: Power BI Studio…
Using TMDL in Power BI Desktop to bulk replace – Saving me hours of time
It is great to see the advancements in Power BI with regards to TMDL. Recently I was working on a customer’s semantic model where I was doing some optimizations in the semantic model. One of the changes I wanted to make was to replace the Dynamic Format String for the measures. My challenge was that there were roughly 40 measures…
Using a Microsoft Fabric Notebook to get all Power BI Licenses
In this blog post I am going to show you how to get all the Power BI licenses in your tenant. This can be very useful to understand how many licenses you have, what type of licenses are being paid for, and potentially how you can save by removing licenses due to inactive use or if the licenses are no…
Understanding what is consuming your Fabric Storage
This blog post will show you how to understand what is consuming your Fabric Storage. If you want to know how I got this data, please read my previous blog post View all your Storage consumed in Microsoft Fabric – Lakehouse Files, Tables and Warehouses – FourMoo With this Semantic model below, I could also create alerts to notify based…
Did you know external (Guest) users can connect to your Semantic Model using Excel?
Yes, you read that right, it is possible where you have shared Power BI semantic model with an external (guest user in Entra ID) they can now connect to the semantic model using Excel. This has been around for quite a while I just did not know about it, here is the Microsoft documentation: Semantic model connectivity and management with…
How to get data from a Fabric Lakehouse File into Power BI Desktop – Using Scanner API JSON
How to get data from a Fabric Lakehouse File into Power BI Desktop – Using Scanner API JSON In this blog post I am going to show you how I connected to my Scanner API JSON file which is stored in the files section of my Microsoft Fabric Lakehouse. Full credit on how to complete this comes from Marc’s blog…