API - Admin - WorkspaceInfo GetScanResult is not returning tables, queries and columns information

[verdan]

Hello, 

I am new to PowerBI Rest API, and need to get the complete information about a dataset. I see this information on the frontend, that a dataset has the tables, or queries. but when using the Admin WorkspaceInfo GetScanResult endpoint, the tables list is empty for all the datasets, and only one dataset has the DAX expression query. 

I have all the query params set as True:

and the endpoint response:

Any help on what I am missing?

the frontend lineage view:

[algaindra99123]

Hello @verdan 

Have you solved the problem? If you don't mind, please kindly replying me and send me a messages.
Thank you

[vivien57]

Hello,

Have you managed to solve your problem? I have the same problem

Thank you in advance for your feedback,

Have a nice day,

Vivien

[Anonymous · Accepted solution]

HI @verdan,

As the document said, have you invoked GetScanStatus API before using GetScanResult? The detail result seems generated by ScanStatus API.

Admin - WorkspaceInfo GetScanResult - REST API (Power BI Power BI REST APIs) | Microsoft Learn

In addition, please also check the correspond permissions and scope settings of that API usage and confirm your dataset has been refreshed/republished to actived the scanning API:

Solved: Enhaced Metadata scanning doesn't retrieve tables - Microsoft Power BI Community

Regards,

Xiaoxin Sheng