topic Power BI REST API in Developer

Power BI REST API

Anonymous — Fri, 09 Jul 2021 14:02:24 GMT

Hi everyone , I'm trying to get all the datasources for my organization.I'm using a service principal to connect to Power BI Service.
I made a function with PowerShell where I have made a this loop to get all the datasetId.

$OrgWorkspaces = Get-PowerBIDataset -Scope Organization
foreach ( $OrgWorkspace in $OrgWorkspaces)
{
$DatasetId= $($OrgWorkspace.Id)
# Write-Host $DatasetId

}

And this worked But when I added this line of code
$DataSources = Get-PowerBIDatasource -DatasetId $DatasetId
into the loop It didn't work ! I tried to put a DatasetId from the list I had
$DataSources = Get-PowerBIDatasource -DatasetId 1505150a-36f2-408e-a1e7-3531e6e0fccf *** but I have this error:
[Error] ERROR: Operation returned an invalid status code 'Forbidden'Exception :Type : Microsoft.Rest.HttpOperationExceptionRequest :Method : GETRequestUri : https://api.powerbi.com/v1.0/myorg/datasets/1505150a-36f2-408e-a1e7-3531e6e0fccf/datasourcesHeaders :Authorization : …User-Agent : MicrosoftPowerBIMgmt/1.2.0.0Response :StatusCode : ForbiddenReasonPhrase : ForbiddenContent : {"Message":"API is not accessible for application".

Any idea of this error please?

Re: Power BI REST API

Anonymous — Mon, 12 Jul 2021 08:24:00 GMT

Hi @Anonymous ,

According to the error message, it seems that you do not have the appropriate permission to view the data source information of this data set. Please confirm whether to Enable service principal authentication for read-only admin APIs and check whether to add the service principal as a member or admin to your workspace. Change your cmdlet scripts as below and check whether it can work well, you can refer the content in this blog: POWER BI ADMIN DATASETS .

Note: Please make sure the dataset id is correct.

$DataSources = Get-PowerBIDatasource -DatasetId 1505150a-36f2-408e-a1e7-3531e6e0fccf *** -Scope Organization

In addition, please review the following rest API and check whether it can get your desired result.

Admin - Datasets GetDatasourcesAsAdmin

Best Regards

Re: Power BI REST API

Anonymous — Wed, 21 Jul 2021 12:35:22 GMT

Thank you for your answer!