Get all data table from API

[BigMoo]

Hello, I want to automatically get all the sources used in my differents published dashboards.
When i use the API to get the sources from one dashboard i can only see the tables which are in its semantic model.
In lots of dashboards I have some tables which are not loaded in the semantic model but provide datas to other tables which are in the semantic model.

I'd like to know if there is a way to get "all" the data tables via an API (all the tables one can see when he opens power query in PowerBi desktop)

Thx, in advance.

[Anonymous]

Hi @BigMoo ,

Based on your description, you can use the Datasets GetTables API call that can list tables in a given dataset, but it has limitations and may not include all tables, especially those that are not in the semantic model.

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

You can also get the table through dax studio using something like the DMV statement

Solved: Table List and Field List - Microsoft Fabric Community
You can refer to the following documents for detailed information

How to get a tables list from datasets published w... - Microsoft Fabric Community

Best regards,
Albert He

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

[BigMoo]

Hello,

We allready use the rest API and indeed, we have only the tables loaded in the semantic model.

I tried the solution with Dax Studio (even if it's not possible to automate this solution) and the problem is the same : only semantic model.

To explain our context, we opened our pbi server to self analytics and we want to track automatically all the data sources used in the each published dashboards. It happens quite often that people loads data in power query tables then merge thoses tables in another table. Only the last table we'll be in the semantic model and we lose track of the original data sources...