How to list all the underlying tables for all the reports in the organisation?

[Poorab]

A part of an database impact analysis, we need to know the underlying database tables/views used in all the reports in the organisation. 
Can it be achived using the REST APIs or the Admin console?
If so, please guide.

[Anonymous]

Hi,  @Poorab 

If you are using Power BI, you can use the Power BI REST API to achieve this. Use the Get Reports API to list all reports. For each report, use the Get Report Data Sources API to fetch the underlying tables and views. You can check the following links:

Power BI REST APIs for embedded analytics and automation - Power BI REST API | Microsoft Learn

Datasets - REST API (Power BI Power BI REST APIs) | Microsoft Learn

For Tableau, you can use the Tableau Server REST API. You can learn more about this:

Tableau Server REST API - Tableau

Reference-Tableau Server REST API - Tableau

How to Get Your Question Answered Quickly

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Poorab · Accepted solution]

Thank you @Anonymous for sharing the links to the Power BI REST APIs.

I figured out that we can get the list of all the reports in organisation using Admin - Reports GetReportsAsAdmin, it lists all datasets id related to the reports as well.
Then use Push Datasets - Datasets GetTablesInGroup to list the underlying tables for each dataset. 

Thanks a lot!

[lbendlin]

Announcing Scanner API (Admin REST APIs) enhancements to include dataset tables, columns, measures, ...

[Poorab]

Thanks @lbendlin for pointing me in the right direction.

I have figured out that we can get the list of all the reports in organisation using Admin - Reports GetReportsAsAdmin, it lists all datasets id related to the reports as well.
Then use Push Datasets - Datasets GetTablesInGroup to list the underlying tables for each dataset. 

Thanks you!

[lbendlin]

Then use Push Datasets - Datasets GetTablesInGroup to list the underlying tables for each dataset. 

I don't think your organization is using Push datasets. These are different from standard semantic models.

[Poorab]

Oh, did not realise it.
I wasnt able to find any other documentation to get the underlying tables.
Please guide me if you are aware of any such documentation.

[lbendlin]

You use the API to enumerate all semantic models and then run the DMV queries. For dataflows there is an API call to export the .json