Forum Discussion

grasshoppa's avatar
grasshoppa
New Member
2 years ago

Find Power BI data sources for on premise server

How can I run a query (sql, powershell, or rest) to find all the data sources of my Power BI dashboards?  Most the documentation is around using powershell but the soultions are all against the cloud Power BI service.

I have a local/on premise Power BI server and I am trying to document the SQL server names and databases for each of the published dashboards.  It would be helpful if it looped through all the dashboards in the sub folders so I don't have to manually add the indivdual dashboards.

Dashboards
data sources
on premise
power bi server
script

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.