topic Re: API - Admin - WorkspaceInfo GetScanResult is not returning tables, queries and columns informati in Developer

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

verdan — Wed, 02 Nov 2022 09:20:04 GMT

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:

Re: API - Admin - WorkspaceInfo GetScanResult is not returning tables, queries and columns informati

Anonymous — Thu, 03 Nov 2022 02:02:23 GMT

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

Re: API - Admin - WorkspaceInfo GetScanResult is not returning tables, queries and columns informati

vivien57 — Mon, 02 Dec 2024 13:40:37 GMT

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

Re: API - Admin - WorkspaceInfo GetScanResult is not returning tables, queries and columns informati

algaindra99123 — Mon, 07 Apr 2025 03:22:05 GMT

Hello @verdan

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