Find Power BI data sources for on premise server

Hi grasshoppa ,

For on-premise Power BI Report Server, leveraging PowerShell in conjunction with the Reporting Services Tools can be a viable approach. The Reporting Services Tools provide cmdlets for managing items in a report server in native mode or a Power BI Report Server.

First, ensure you have the GitHub - microsoft/ReportingServicesTools: Reporting Services Powershell Tools installed. You can install it via PowerShellGet with the following command:

Install-Module -Name ReportingServicesTools

Once installed, you can use the cmdlet (RsItemDataSource) to retrieve information about data sources for reports. You'll need to loop through the items (reports and dashboards) in your server's folders to gather this information.

Import-Module ReportingServicesTools
$reportServerUri = "http://yourReportServer/ReportServer"
$folderPath = "/PathToYourDashboardsFolder"
Get-RsFolderContent -ReportServerUri $reportServerUri -RsFolder $folderPath | Where-Object Type -EQ "Report" | ForEach-Object {
  $reportPath = $_.Path
  Get-RsItemDataSource -ReportServerUri $reportServerUri -RsItem $reportPath
}

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.