Forum Discussion

nkasdali's avatar
nkasdali
Microsoft Employee
5 years ago
Solved

GetDatasourcesAsAdmin Powershell help

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...
Need Help
Show and Tell
Tips and Tricks
  • v-lionel-msft's avatar
    v-lionel-msft
    5 years ago

    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.

     

nkasdali's avatar
nkasdali
Microsoft Employee
5 years ago

Up 😞

  • v-lionel-msft's avatar
    v-lionel-msft
    Community Support
    5 years ago

    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.

     

    • nkasdali's avatar
      nkasdali
      Microsoft Employee
      5 years ago

      Thank you 🙂