Dashboards DataSource

[omnia_saleh]

I putted a Datasource of each Dashboard published on PowerBI Report Server on a connection string but It Encrypted In Reportserver in table DataModelDataSource how can I decrypt it to get the Datasource of each Dashboard?

[d_gosbell · Accepted solution]

You should never access the ReportServer database directly (apart from the execution log views) as it can cause issues with the operation of the Report Server. You can use the REST API (eg Power BI Reports - Get Power BI Report Data Sources - REST API (Power bi report) | Microsoft Learn) to extract information like the data source details.