topic PowerBi embeded data sources query in Report Server

PowerBi embeded data sources query

tcschroeder — Wed, 20 Apr 2022 14:51:36 GMT

I am looking for a way to query the ReportServer database to find the name of the embeded data sources in a PowerBi report. I know how to do this for SSRS reports, but can't figure out how to get it for PowerBi reports.

Re: PowerBi embeded data sources query

v-luwang-msft — Mon, 25 Apr 2022 05:51:31 GMT

Hi tcschroeder ，

You could obtain the data source name corresponding to the report in the specified database through the following TSQL query:

USE [ReportServer] GO SELECT CATALOG.NAME ,CATALOG.[Path] ,DataSource.NAME datasource ,CATALOG.[Description] ,Created.UserName AS CreatedByUser ,CATALOG.[CreationDate] ,Modified.UserName AS ModifiedByUser ,CATALOG.[ModifiedDate] FROM [dbo].[Catalog] LEFT JOIN ( SELECT [UserID] ,[UserName] FROM [dbo].[Users] ) AS Created ON CATALOG.CreatedByID = Created.UserID LEFT JOIN ( SELECT [UserID] ,[UserName] FROM [dbo].[Users] ) AS Modified ON CATALOG.ModifiedByID = Modified.UserID JOIN DataSource ON CATALOG.ItemID = DataSource.ItemID JOIN CATALOG cat1 ON DataSource.Link = cat1.ItemID WHERE CATALOG.[Type] = 2 ORDER BY [Path] ,NAME

And you could get data from sql through using Power BI.

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien

Re: PowerBi embeded data sources query

tcschroeder — Mon, 25 Apr 2022 14:12:49 GMT

Actually no. This is showing the data sources for the SSRS reports (.rdl's). That is what I am able to get. What I am interested in is the data sources for PowerBI documents (.pbix).

Re: PowerBi embeded data sources query

v-luwang-msft — Tue, 26 Apr 2022 03:21:08 GMT

Hi tcschroeder ,

Power BI Desktop as a tool does not have a corresponding database (like when report server is deployed, a corresponding database is created, so we can look up its data source information via sql). We need to use Power BI Desktop to open the PBIX file and then view the data source through the following interface.

Best Regards

Lucien