GetScanResult - The list of tables is often empty

[vivien57]

Hello everyone,

I'm having a rather incomprehensible problem.

I call the WorkspaceInfo GetScanResult method and the list of tables and columns for a workspace is sometimes available, sometimes not (empty list)...

And yet all the Datasets are scheduled in Power BI Service...

I've also noticed that if you force a refresh in PowerBI Service (On-Demand and not Scheduled), the data is then available.

Do you also experience this problem ?

Why do you have to force a refresh for the data to be available ?

Thank you in advance for your feedback,

Have a nice day,

Vivien

[Anonymous]

Hi @vivien57 ,

As far as I know, this rest api will get the scan result for the specified scan.

According to the offical blog Admin - WorkspaceInfo GetScanResult , we can only make this API call after a successful GetScanStatus API call. The scan result will remain available for 24 hours.

Best Regards,
Rico Zhou

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

[vivien57]

Hello,

Thank you for your feedback.

I did read the documentation, but as I mentioned in my post, sometimes the information is there and sometimes it's not.

And there's nothing in the documentation to explain this problem, or why forcing an on-demand refresh seems to solve it.

Thank in advance for your return,

Vivien

[Anonymous · Accepted solution]

Hi @vivien57 ,

As the offical blog mentioned, we need to call  Admin - WorkspaceInfo GetScanResult after a successful GetScanStatus API call.
Please make sure you have called GetScanStatus  API call successfully first.

I suggest you to refer to this blog to follow the steps: Using the Power BI Scanner API to Manage Tenant’s Entire Metadata – PowerBI.tips

And there is a solved thread with similar issue like yours for reference: 
Solved: Re: API Scanning Metadata - Microsoft Fabric Community

Best Regards,
Rico Zhou

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