Get list of all the reports that are using a particular SQL view from SQL query embedded in report

[piyushdadhich]

I have a some 100 reports in my 20 workspaces. Each report has some 10 tables. Many of the tables in those reports are pulling data from the data source using the SQL statement written in the query window. I got to change something for a particular view that is used in many of those queries used in reports.

How could i find all the reports that contain the SQL view i need change. I need the list of it. What is the best way to do this rather than searching manully each report and table in the report.

[Shahid12523]

Use Power BI Scanner API → extract dataset queries across all workspaces → search for your SQL view.

Alternatives:

PowerShell (Get-PowerBIDataset) to read queries.

Download PBIX and search inside (last resort).

Best: Scanner API for full list at once.

[V-yubandi-msft]

Hi @piyushdadhich ,

That’s a really helpful suggestion @GilbertQ , the Scanner API is definitely the best way to handle this, since it gives you all the metadata across workspaces in one place.

Just adding one note: you’ll need Power BI Admin rights to run the Scanner API. If you don’t have that access, you might need to loop in your admin. 

Thanks for your response @GilbertQ .

regards,
Yugandhar.

[GilbertQ]

Hi @piyushdadhich 

The Scanner API can extract all this information for you where once loaded, you can then use Power BI Desktop to interrogate the data and to find the tables and associated views for your reports. Here is a link on how to download the scanner API data. Which Power BI Reports do I have access to? - Part 1 – Using the power BI Scanner to get App Workspa...