Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreShape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.
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!!!!!!!!
Solved! Go to 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.
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.
Proud to be a Super User! Regards, Bipin Lala | Business Intelligence Developer | |
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.
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.
Proud to be a Super User! Regards, Bipin Lala | Business Intelligence Developer | |
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.
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.
Proud to be a Super User! Regards, Bipin Lala | Business Intelligence Developer | |
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
User | Count |
---|---|
94 | |
90 | |
83 | |
76 | |
49 |
User | Count |
---|---|
145 | |
141 | |
109 | |
69 | |
55 |