topic how to find out sql server tables used in the reports of power bi report server in Report Server

how to find out sql server tables used in the reports of power bi report server

Anonymous — Mon, 12 Dec 2022 14:42:48 GMT

I want to review BI reports to get database, schema , table names and queries which was used to create the report.
The reports are in power BI Report Server

is there a way to check these details manually ? (without using power query tool)

Thanks in advance

Re: how to find out sql server tables used in the reports of power bi report server

Shahfaisal — Mon, 12 Dec 2022 16:13:21 GMT

The best way is to download the report and look at the code in Power BI Desktop. If you don't have that option, you can try the below:

1. If you are uding Direct Query: Setup a trace in SQL Server to see what tables are being queried when users are interacting with the report.

2. If you are using Import Mode: Setup a trace in SQL Server to see what tables are being queried when the data refresh is taking place.

Again, best is to download the file and look at the code behind it.

Re: how to find out sql server tables used in the reports of power bi report server

jquintero — Fri, 26 May 2023 18:16:11 GMT

I have a similar problem but I need a solution that allows me to find this information on many Power BI reports at the same time.

This is the use case:

We have about 50 Power BI reports using multiple datasets. Most of them where built using SQL queries pulling data from a MS SQL server. IT advised us there will be a change in one of the systems which will affect how we are calling some of the tables we are using. So we need to know which Power BI dashboards will be impacted.

I know I can open one by one and verify but there has to be a more efficient way. I know the PBIX files are zip files and the mqueries are in there, but how can I search thorugh all the 50 pbix files automatically?

Thanks in advance,

Jorge Quintero

Re: how to find out sql server tables used in the reports of power bi report server

Anonymous — Fri, 22 Dec 2023 16:50:51 GMT

I've recently ran into this same issue (400+ reports and 300+ tables in my workspace) and couldn't find a simple solution to find which reports are utilizing which tables. I wrote a simple Python script to help with this. I posted it on my GitHub and hope that someone else that searches these forums finds it useful. I have directions for it in the README.

https://github.com/Askrr/PBI_tableLookUp/tree/main

Re: how to find out sql server tables used in the reports of power bi report server

Anonymous — Fri, 22 Dec 2023 16:51:16 GMT

https://github.com/Askrr/PBI_tableLookUp/tree/main