Forum Discussion
Certain dataset tables/columns are not returned from the Admin - WorkspaceInfo GetScanResult endpoin
Community SupportHi brechtarnou ,
If you set the datasetSchema or datasetExpressions parameters to true , you must fully enable metadata scanning in order for data to be returned. For more information, see Enable tenant settings for metadata scanning.
What type of authentication are you using?
The user must have administrator rights (such as Microsoft 365 Global Administrator or Power BI Service Administrator) or authenticate using a service principal.
Here is the blog for your reference:
https://debbiesmspowerbiazureblog.home.blog/category/power-bi-admin-scanner-api/
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Liang,
We use the service principal to authenticate.
All the steps of the blog were also followed. We have enabled both flags for our security groups.
The thing is that we have certain datasets that return all the metadata, having the tables and the columns/measures. Other datasets in the same workspace do not return all the metadata.
But we cannot see a clear reason why certain datasets return their metadata and others not.
Kind regards,
Brecht
- vivien57
Super User
Hello,
I have exactly the same problem, some return metadata for tables/columns and not others.
Even though they are both schedulers in the service.
Have you found the source of the problem?
Thanks in advance for your return,
Vivien
