Enhaced Metadata scanning doesn't retrieve tables

[Lars_c]

Hi all,

I've set up the scanning API by following all the steps provided by Microsoft. This works, as it shows the lineage, datasets, users, datasources, reports,... The lowest level it shows in the dataset is only the dataset itself. For the tables, dax expressions and M query mashups, the script returns a blank like this:

"tables" : []

Most of the datasets are Import (i know it doesn't work with DirectQuery).

The data comes from an SQL server (on prem).

The settings for enhanced metadata in the admin dashboard are on.

The url for initiating the scan has every parameter set to "True".

Am i missing something that creates this behaviour?

[v-shex-msft · Accepted solution]

HI @Lars_c,

It seems like a common scenario that happens when your use scanning API on datasets that have not been refreshed or republished. You take a look at the official document and it mentions these situations in 'Considerations and limitations':

Metadata scanning - Power BI | Microsoft Docs

Datasets that have not been refreshed or republished will be returned in API responses but without their detailed low-level information and expressions. For example, you will see dataset name and lineage in the response, but not the dataset's table and column names.
Regards,

Xiaxoin Sheng