Power BI Premium | Extract PBIX files data

[lelalaoui]

Hello friends,

Hope you are all safe.

I need your help regarding Power BI premium, to extract via Powershell all available attributes for pbix files.., my goal is to have something like this :

Workspace name | Report name | Owner | Size | Updaloaded datetime | Lastmod dattime

Is this something doable ?

Thank you for your help and best regards.

[ibarrau · Accepted solution]

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,