Forum Discussion
Solved
Testing Database Changes Against Suite of Reports
Hi All, I've inherited a mature SQL Server data environment that has been completely uncontrolled for a long time. It had been run as a single production server environment, i.e. no dev or test ...
Use the Scanner API to harvest all queries for the Power BI data sources. That will tell you which SQL server tables, views etc are contributing.
That did the trick, thank you. For future viewers of this topic, I needed to create a scan request via a PostWorkspaceInfo call, wait for this to complete successfully and then get the results using GetScanResult. This returns a huge amount of very useful information about your PBI setup.
Admin - WorkspaceInfo PostWorkspaceInfo - REST API (Power BI Power BI REST APIs) | Microsoft Learn
Admin - WorkspaceInfo GetScanResult - REST API (Power BI Power BI REST APIs) | Microsoft Learn