Forum Discussion
Find Custom Visual Use in Reports?
I am an administrator looking to get a handle of the custom visuals that are currently being used and hosted in our tenant. We are exploring limiting visuals to only certified visuals, but we don't want to disable uncertified visuals if it would break a significant number of reports in production.
Question: Is there a way to see which custom visuals are in use in a tenant? (without going through thousands of reports and checking...)
4 Replies
SeattlePowerBI I know of one rather crude way but it may not scale for you.
Custom visuals are embedded in the pbix files.
So what you would have to do is
- get a list of all workspaces and their reports
- add yourself to the admins of the workspace
- download the pbix for each report via Reports - Export Report In Group - REST API (Power BI Power BI REST APIs) | Microsoft Docs
- look inside the PBIX ZIP file and extract the custom visual information
This can all be automated but it would still take a lot of time if you have more than a couple hundred workspaces.
Note: You can also parse the Layout JSON file inside the PBIX
Hi There! Yes, I have used that trick for indivual reports, but as you mentioned; scale is an issue. Hoping that there is some way to determine use in the entire tenant / scan thousands of reports.
Thank you for replying! I am sure that your comment will be helpful for others looking to examine the contents of the pbix.
SeattlePowerBI Were you ever able to find a scalable solution to your issue? If so, would be great to hear your experience.
Here is a slightly more automated version
