How do I generate a list of data sources for multiple PBI Reports with data from SQL Server or Azure?

Question

How do I generate a list of data sources for multiple PBI Reports with data from SQL Server or Azure?

Jacob Pratt 0

I have several hundred powerBI reports that point to different views / tables in a SQL server data warehouse and an Azure cloud environment.

Is there a way for me to generate a list of the views and tables that these reports query without having to go through the query editor for each report one by one?

GeethaThatipatri-MSFT 23,947 Reputation points Microsoft Employee

2023-11-28T16:16:51.3466667+00:00

Hi @Jacob Pratt I am checking to see if you got a chance to look into the above response. Please let me know if you have any further questions.

If this answers your question, please consider accepting the answer by hitting the Accept answeras it helps the community look for answers to similar questions.

Regards

Geetha

GeethaThatipatri-MSFT 23,947 Reputation points Microsoft Employee

2023-11-28T16:16:51.3466667+00:00

Hi @Jacob Pratt I am checking to see if you got a chance to look into the above response. Please let me know if you have any further questions.

If this answers your question, please consider accepting the answer by hitting the Accept answeras it helps the community look for answers to similar questions.

Regards

Geetha

Answer 1

Nandan Hegde 27,316 MVP

Hey,

For PowerBI related query, please post in PowerBi community :

https://community.fabric.microsoft.com/t5/Microsoft-Power-BI-Community/ct-p/powerbi

You can refer the similar query :

https://stackoverflow.com/questions/76055378/get-sql-query-from-powerbi-report-dataset

How do I generate a list of data sources for multiple PBI Reports with data from SQL Server or Azure?

1 answer

Activity