Forum Discussion

SeattlePowerBI's avatar
SeattlePowerBI
Helper III
4 years ago

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 w...
Need Help
lbendlin's avatar
lbendlin
Super User
4 years ago

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

 

 

 

  • SeattlePowerBI's avatar
    SeattlePowerBI
    Helper III
    4 years ago

    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.

    • dereknguyen's avatar
      dereknguyen
      Microsoft Employee
      3 years ago

      SeattlePowerBI Were you ever able to find a scalable solution to your issue? If so, would be great to hear your experience.