PowerShell - I want to get Power Bi data sources from PowerShell Script- Using Azure cloud Runbook

[krish11]

I am using Powersehll in Azure run book with Service principal account to connect PowerBI. However, I am unable to fetch the datasource with the help of Report ID.

I've tried the below API to get the datasources based on the reportid but powershell encountered an error.

GET https://api.powerbi.com/v1.0/myorg/reports/{reportId}/datasources

Source Code example.

/*

$url = "https://api.powerbi.com/v1.0/myorg/reports/923F77B5-442B-9C78-1E3E-634141412C39/datasources"

$wreContainer = Invoke-PowerBIRestMethod -Url $url -Method Get | ConvertFrom-Json

$wreContainer 

*/

I am getting below error when I ran this code. Not able to find what it is trying to say.

I really appreciate your help. Please please help me. Thank You in Advance...

[v-easonf-msft]

Hi, @krish11 

Can you provide more error information?

You can also open a support ticket to let engineers look into the issue on your side.

https://powerbi.microsoft.com/en-us/support/pro/ 

Best Regards,
Community Support Team _ Eason