Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to Solution.
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
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
Thank you for your answer!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
13 | |
2 | |
2 | |
1 | |
1 |