Forum Discussion
Power BI Premium | Extract PBIX files data
- 4 years ago
Hi. You might be able to do this yes. The only thing is that is might not be as straight foward as you think. You can do this with the Power Bi Rest API:
https://docs.microsoft.com/en-us/rest/api/power-bi/In there you can find requests to get workspaces, reports from workspaces, etc. If you are familiarized with powershell or any other coding language, feel free to start requesting to build your table.
You can do it in two ways.
1- Get workspace and then loop those getting reports from workspaces. Create a table from jsons involved.
https://docs.microsoft.com/en-us/rest/api/power-bi/admin/groups-get-groups-as-admin
https://docs.microsoft.com/en-us/rest/api/power-bi/admin/reports-get-reports-in-group-as-admin
2- Get all data with the new scanner api. It's a little bit trickier but it gets all data from a single request paginated. https://docs.microsoft.com/en-us/rest/api/power-bi/
NOTE: you need to use a Power Bi Admin account or a Service Principal with Read Admin API Permissions to use those requests.
Once you build the script to capture all that you can store it somewhere to consume it easier.
I hope that helps,
Hi. You might be able to do this yes. The only thing is that is might not be as straight foward as you think. You can do this with the Power Bi Rest API:
https://docs.microsoft.com/en-us/rest/api/power-bi/
In there you can find requests to get workspaces, reports from workspaces, etc. If you are familiarized with powershell or any other coding language, feel free to start requesting to build your table.
You can do it in two ways.
1- Get workspace and then loop those getting reports from workspaces. Create a table from jsons involved.
https://docs.microsoft.com/en-us/rest/api/power-bi/admin/groups-get-groups-as-admin
https://docs.microsoft.com/en-us/rest/api/power-bi/admin/reports-get-reports-in-group-as-admin
2- Get all data with the new scanner api. It's a little bit trickier but it gets all data from a single request paginated. https://docs.microsoft.com/en-us/rest/api/power-bi/
NOTE: you need to use a Power Bi Admin account or a Service Principal with Read Admin API Permissions to use those requests.
Once you build the script to capture all that you can store it somewhere to consume it easier.
I hope that helps,