Which Power BI Reports do I have access to? – Part 1 – Using the power BI Scanner to get App Workspace data.
As mentioned in my previous blog post this is part 1 of the series where I am going to show you how to use the Power BI Scanner to get the App workspace data. I am also going to mention that the Power BI Scanner from PowerBI.Tips and Tommy Puglia (Twitter) has a wealth of other awesome information for your Power BI tenant.
Fortunately I do not have to go through all the steps on setting up and getting the Power BI Scanner data, you can do it by following the blog post already created with some amazing details here: Using the Power BI Scanner API to Manage Tenant’s Entire Metadata
For those who have not use the above blog post I would like to highlight that you would need to have the following pre-requisites already completed (Which you can also find in the blog post)
- Created an Azure Service Principal to be used for Power BI Read-Only Admin APIs
- An Azure App which will contain the App Key and client secret
- Created a Azure Active Directory Security Group to host the App
- Enabled and configured the Azure Service Principal to use the Power BI Read-Only APIs in your Power BI tenant.
SharePoint location where the API request details will be stored.
First you would need the SharePoint Library name. As shown below.
Next you would need to put in the folder location where the files will be stored. As shown below this was my location
Then the final thing to make a note of for the SharePoint locations is the trigger which will start off the entire refresh process
Just to show you what this looks like in my SharePoint folder locations this is what it looks like when I created the folders in SharePoint Online.
- Power Automate Flow access which will handle the entire API request and scheduling.
- Downloading the Power BI Template file to get the data from the metadata results.
Once all has been done you will have all the data downloaded from the Power BI Scanner and view the data in Power BI desktop. I used the PBIT from the Power BI Tips blog link.
What I did was I only kept the following table as shown below.
This is the table which contains all the Workspaces Names, which is what I wanted to get from the Power BI Scanner API.
As shown below this is what my workspacesbl table looks like
I then saved my PBIX file as “Power BI Users Reports List.pbix”
In this blog post I have shown you how I used the blog post from Power BI tips and Tommy Puglia to download all the Power BI Scanner API Data. I then only kept the table workspacesbl.
I hope that you found this useful and please let me know if you have any comments or suggestions.
In the next blog post I will show you how I got all the App and users who are part of the app into my Power BI file.