topic Re: GetDatasourcesAsAdmin Powershell help in Developer

GetDatasourcesAsAdmin Powershell help

nkasdali — Thu, 04 Feb 2021 22:17:39 GMT

Hi All,

I need your help to build this ForEach loop, unfortunately i'm not familiar with PowerShell.

First API call helps me to get all my datasets, then, i have to passe the "id" of each one to the datasource APi call :

################## GET Datasets DATA########################################### Write-Host("Getting datasets data.....") $DatasetsApi = 'https://api.powerbi.com/v1.0/myorg/admin/datasets?$top=2' $DatasetsCall = Invoke-PowerBIRestMethod -Url $DatasetsApi -Method Get ################## GET Datasources DATA########################################### ForEach ($DatasetsCall in $DatasetsCall) { $DatasourceApi = 'https://api.powerbi.com/v1.0/myorg/admin/datasets/&'+$DatasetsCall.id+'&/datasources' $DatasourceCall = Invoke-PowerBIRestMethod -Url $DatasourceApi -Method Get $DatasourceCall }

Thank you for your help

Re: GetDatasourcesAsAdmin Powershell help

nkasdali — Fri, 05 Feb 2021 12:15:13 GMT

Up 😞

Re: GetDatasourcesAsAdmin Powershell help

v-lionel-msft — Tue, 09 Feb 2021 05:57:13 GMT

Hi @nkasdali ,

Please try this.

################## GET Datasets DATA########################################### Write-Host("Getting datasets data.....") $DatasetsApi = 'https://api.powerbi.com/v1.0/myorg/admin/datasets?$top=2' $DatasetsCall = Invoke-PowerBIRestMethod -Url $DatasetsApi -Method Get ################## GET Datasources DATA########################################### ForEach ($DatasetsCall in $DatasetsCall) { $DatasourceApi = "https://api.powerbi.com/v1.0/myorg/admin/datasets/" + $DatasetsCall.Id + "/datasources" $DatasourceCall = Invoke-PowerBIRestMethod -Url $DatasourceApi -Method Get $DatasourceCall }

Best regards,
Lionel Chen

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

Re: GetDatasourcesAsAdmin Powershell help

nkasdali — Tue, 09 Feb 2021 08:25:38 GMT

Thank you 🙂