How to get Workspace metadata in PowerBI

[mansonwy]

As shown below, this is the usual table we can see once we enter any workspace. 
Is there anyway other than using API to 'Get data' in Powerbi? 
If no, please let me know how I may call the API by using python. Thanks a lot with the help!!!!!!!!

[Bipin-Lala · Accepted solution]

Hi @mansonwy,

To get the Workspace Metadata and other Power BI Tenant Catalog data, you would have to make use of Power BI REST APIs in one way or another.

Means you can call the APIs in multiple ways, like using Python as you mentioned, or even calling the API directly in Power BI using Web connector in Get Data. You can also make use of PowerShell cmdlets.

The Get Group API would be the starting API to help you in getting the data. (use the Try It section in the documentation page to see what data it returns for your workspace) Please follow the links below that detail the steps needed to connect to Power BI APIs and get data.

• https://data-goblins.com/power-bi/power-bi-api-python
• https://www.youtube.com/watch?v=APj3MFt2w5I&ab_channel=JJPowerBI
• https://www.youtube.com/watch?v=cTqFNg_y9lw&ab_channel=BIElite (Using APIs directly in Power BI to build Power BI Governance Model)

You should be able to find numerous blogs and videos that should help you in getting started with using Power BI APIs.

PS: You would require appropriate permissions to access APIs or app registrations with appropriate permissions and access to Power BI read-only admin APIs.

At our place, we are making use of app registrations along with PowerShell scripts to fetch Power BI Tenant activity and catalog data.

Let me know if you need any further help.

[mansonwy]

Thanks so much @Bipin-Lala !! Unfortunately, due to security issue I can only access to below. I do not have the access for tenant.all. However according to the scope of Microsoft Learn https://learn.microsoft.com/en-us/rest/api/power-bi/capacities/get-refreshables#code-try-0 it should be ok. But I am still having Error 401. 

[Bipin-Lala]

Hi @mansonwy,

To make use of Service Principal Authentication for accessing Power BI APIs such as Capacities - Get Refreshables, you would have to configure certain settings in the Power BI Admin Portal so that Service Principal can access Power BI read-only APIs. The permissions granted in the Azure Portal do not work and will have to be removed.

The steps are explained in detail here - https://learn.microsoft.com/en-us/power-bi/enterprise/read-only-apis-service-principal-authenticatio...

Get Refreshables are also part of the APIs list documented in the above link.