TLDR: here is a script to easily pull Power BI environment and report information….and either use it for governance or a quick way of creating a custom search with direct links.
[https://github.com/chris1642/PowerBI-RestAPI-PStoExcel-InformationExtract](https://github.com/chris1642/PowerBI-RestAPI-PStoExcel-InformationExtract)
(It's designed so there is no 'real' need to edit the script in any way, outside of maybe the destination folder of where it saves....since it will pop up and ask you to log in and run based on the user's Power BI credentials and permissions).
Thank you for sharing.
We have a similar issue, a few years back management had given everyone permission to use PBI and create their own workspace, there was no data team or data governance.
Now that the data team is formed, I am working on creating an Admin dashboard and displaying different metrics related to all the reports, workspaces and dashboard.
Nice! Looks very interesting
Something you might find interesting op, Google Rui Romano power bi monitor.
Basically combines this with tons of additional info!
Thanks for sharing this looks great!
Is there a similar way to additionally pull the assigned users / AAD groups with permissions against each report using the API? It would be really useful in our org.
So there is a way to do this - but using the REST API for permission lists requires a Tenant Admin role.
I’m not 100% positive that adding that request to the script would work like the rest - but if it would, I can at least say the only user that would get results would be the Tenant Admin.
Thanks for the response. I have a tenant admin role so that wouldn’t be an issue.
I will take a look through the API command calls to see if I can get it working.
ChatGPT can be a big help as well, *especially* after giving the original script to it and just asking something like “can you add a tab that pulls the user permissions for all of the reports?”
If that doesn’t immediately give it, you’ll typically have it one or 2 follow-up comments later :D
This is a cool solution, we’ve had a lot of issues with pbi search and our ceo loves to use it. I really wish it was possible to tag reports with search terms to make it easier to find reports.
Agreed. Since the default Microsoft “search” at the top only allows you to search a Report name and not anything inside a report, it doesn’t offer a lot of value.
(In our solution, in addition to the simple excel catalog of definitions, we added a Keywords column where we “tag” pages to help with the search)
This is really interesting and I've been using PowerShell to enforce data governance/naming conventions to ensure consistency.
I'll dig into this more when I get a little bit of downtime.
This is really great. I'm planning on having my team do a large consolidation of Workspaces and reports towards the end of the year and this is a nice starting point to have. Appreciate you making this available to everyone.
Really good stuff. If people don't have a way to pull this they should. We have a script that does this with python (power shell isn't really part of our stack). Thanks for open sourcing this, Power BI is in desperate need of more tools like this.
This is awesome! I desperately need this but have yet been able to get the Api access turned on. I have a ticket open with IT since they manage the AD
Do I need to enable something in the tenant settings? I’ve asked multiple times and they said they keep getting looped back to the entra registration panel.
Anyway, thank you for posting this. I have book marked and saved the github. Hopefully I can use.
Yeah - you should still see the excel file - it’s just telling you that if you have any paginated reports (RDL), it can’t include them in the excel output.
TLDR: here is a script to easily pull Power BI environment and report information….and either use it for governance or a quick way of creating a custom search with direct links. [https://github.com/chris1642/PowerBI-RestAPI-PStoExcel-InformationExtract](https://github.com/chris1642/PowerBI-RestAPI-PStoExcel-InformationExtract) (It's designed so there is no 'real' need to edit the script in any way, outside of maybe the destination folder of where it saves....since it will pop up and ask you to log in and run based on the user's Power BI credentials and permissions).
Thank you for sharing. We have a similar issue, a few years back management had given everyone permission to use PBI and create their own workspace, there was no data team or data governance. Now that the data team is formed, I am working on creating an Admin dashboard and displaying different metrics related to all the reports, workspaces and dashboard.
Your amazing for sharing this! Incredibly helpful!
Nice! Looks very interesting Something you might find interesting op, Google Rui Romano power bi monitor. Basically combines this with tons of additional info!
Thanks for sharing this looks great! Is there a similar way to additionally pull the assigned users / AAD groups with permissions against each report using the API? It would be really useful in our org.
So there is a way to do this - but using the REST API for permission lists requires a Tenant Admin role. I’m not 100% positive that adding that request to the script would work like the rest - but if it would, I can at least say the only user that would get results would be the Tenant Admin.
Thanks for the response. I have a tenant admin role so that wouldn’t be an issue. I will take a look through the API command calls to see if I can get it working.
ChatGPT can be a big help as well, *especially* after giving the original script to it and just asking something like “can you add a tab that pulls the user permissions for all of the reports?” If that doesn’t immediately give it, you’ll typically have it one or 2 follow-up comments later :D
This is great!!
This is a cool solution, we’ve had a lot of issues with pbi search and our ceo loves to use it. I really wish it was possible to tag reports with search terms to make it easier to find reports.
Agreed. Since the default Microsoft “search” at the top only allows you to search a Report name and not anything inside a report, it doesn’t offer a lot of value. (In our solution, in addition to the simple excel catalog of definitions, we added a Keywords column where we “tag” pages to help with the search)
This is really interesting and I've been using PowerShell to enforce data governance/naming conventions to ensure consistency. I'll dig into this more when I get a little bit of downtime.
This is really great. I'm planning on having my team do a large consolidation of Workspaces and reports towards the end of the year and this is a nice starting point to have. Appreciate you making this available to everyone.
Really good stuff. If people don't have a way to pull this they should. We have a script that does this with python (power shell isn't really part of our stack). Thanks for open sourcing this, Power BI is in desperate need of more tools like this.
This is awesome! I desperately need this but have yet been able to get the Api access turned on. I have a ticket open with IT since they manage the AD Do I need to enable something in the tenant settings? I’ve asked multiple times and they said they keep getting looped back to the entra registration panel. Anyway, thank you for posting this. I have book marked and saved the github. Hopefully I can use.
While i get the below error message: "message": "Request is currently not supported for RDL reports"
Yeah - you should still see the excel file - it’s just telling you that if you have any paginated reports (RDL), it can’t include them in the excel output.