How to check if a Power BI report contains Custom Visuals

If you want to disable the usage of Custom Visuals inside your Power BI tenant, it is good when you know which visuals already used by your users. To determine the used visuals, you can use PowerShell to download, extract and search for custom visuals inside the published reports. The script below, are simple and must fit to your environment and use a loop over your workspaces and reports.

I have created a Power BI report, imported some custom visuals, and published it to my service.

Login-PowerBI

$reportId = "adf437ba-63ea-47f0-8279-79c893628f9b"
$workspaceId = "dba4761e-abb5-4323-9620-44739e292f9e"
$exportFolder = "c:\temp"

Export-PowerBIReport -WorkspaceId $workspaceId -id $reportId -OutFile $exportFolder"\"$reportId".zip"
Expand-Archive $exportFolder"\"$reportId".zip" -DestinationPath $exportFolder"\"$reportId 

$customVisuals = get-childitem $exportFolder"\"$reportId"\Report\CustomVisuals"
$customVisuals.PSChildName

remove-item $exportFolder"\"$reportId".zip" -Force
remove-item $exportFolder"\"$reportId -Force -Recurse

The script downloads the report, extract the content, and lists the custom visuals which are in use:

Categorized: Allgemein

Comments are closed.