API Metadata Scanner

[manoj883]

Hi,

I have been trying to get tables metadata of the reports using "Get-PowerBITable" or "GetScanStatus", I believe "Get-PowerBITable" can only be used on Push Datasets, correct me if am wrong.
am trying different codes from Powershell one is this one "Invoke-PowerBIRestMethod -Url "https://api.powerbi.com/v1.0/myorg/admin/workspaces/scanStatus/
7395a52c-a64b-4daf-8518-9ad5ffb5de77" -Headers $auth_header -Method GET", and the other you can it below.
Hope someone could help me.
I have admin rights.

[Hariharan_R]

Hi Manoj,

 Get-PowerBITable is applicable for push datasets.

Scanner API is collection of 4 REST APIs. you need to call them in right order to get the expected result. You need call below order.

Ref - https://debbiesmspowerbiazureblog.home.blog/category/power-bi-admin-scanner-api/

Scanner APIs

• GetModifiedWorkspaces
  • GET https://api.powerbi.com/v1.0/myorg/admin/workspaces/modified
• WorkspaceGetInfo
  • POST https://api.powerbi.com/v1.0/myorg/admin/workspaces/getInfo
• WorkspaceScanStatus
  • GET https://api.powerbi.com/v1.0/myorg/admin/workspaces/scanStatus/{scanId}
• WorkspaceScanResult
  • GET https://api.powerbi.com/v1.0/myorg/admin/workspaces/scanResult/{scanId}

Thanks

Hari

Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.

My Blog :: YouTube Channel :: My Linkedin

[manoj883]

Hi Hariharan,

Thanks for the responce, the ref link you mentioned its mostly related to the Azure based app registration and service principle account, but here am trying to execute the scanner API from powershell.
i tried to execute the scanner APIs on powershell.