Forum Discussion

momo_man's avatar
momo_man
Frequent Visitor
2 years ago
Solved

powershell command to get datasource name is not working

Below is my code to try and get the datasource names for all the datasources for every report in my power bi service. It is the workspace and dataset correctly but it is not getting the datasource name correctly. for datasource name it just returns a blank like so, "Datasource: ". But what it does do correctly is return the number of Datasources. So, for example if a report has 3 datasources it will return "Datasource: " 3 times. Any help would be very appreciated. 

 

Install-Module -Name MicrosoftPowerBIMgmt.Data
Login-PowerBI


# Fetch all workspaces

$workspaces = Get-PowerBIWorkspace

 

foreach ($workspace in $workspaces) {

   Write-Output "Workspace: $($workspace.Name)"

 

   # Get datasets for each workspace

   $datasets = Get-PowerBIDataset -WorkspaceId $workspace.Id

   foreach ($dataset in $datasets) {

       Write-Output "  Dataset: $($dataset.Name)"

 

       # Get datasources for each dataset in the current workspace

       $datasources = Get-PowerBIDatasource -DatasetId $dataset.Id -WorkspaceId $workspace.Id

       foreach ($datasource in $datasources) {

           Write-Output "    DataSource: $($datasource.Name)"

       }

   }

}

  • thank yall for the replies it turns out it was a permissions thing

     

6 Replies

  • momo_man's avatar
    momo_man
    Frequent Visitor

    thank yall for the replies it turns out it was a permissions thing

     

    • hmendezm's avatar
      hmendezm
      Regular Visitor

      Thanks momo_man. What permission were you missing?? I am Admin on the workspace and I am not getting Name and connectionstring

    • momo_man's avatar
      momo_man
      Frequent Visitor

      Maybe I will try this. I was trying to do this in less steps. Avoiding any azure interaction with api's with the module. If it worked it would serve its purpose. I just am trying to get the names of all datasources being used in my power bi service

    • bengtsson_peter's avatar
      bengtsson_peter
      Frequent Visitor

      Any idea how you would find the datasource names from the scan? I can't find it 😞

  • foodd's avatar
    foodd
    Community Champion

    Hello momo_man, and thank you for starting a conversation in the Service Forum.    Please mark this reply as a solution once the post is added to the PowerShell Forum.