Forum Discussion

TCavins's avatar
TCavins
Helper V
3 years ago

Powershell Get-PowerBIDatasource - Name is blank

I'm using the following Powershell script to output a file that includes Workspace, dataset and datasource info. The Datasource name is always coming back empty. How can I loop through and get the info I want?

Install-Module -Name MicrosoftPowerBIMgmt -Scope CurrentUser

Login-PowerBI

$Workspace = Get-PowerBIWorkspace –All

$DataSets =

   ForEach ($workspace in $Workspace)

    {
Write-Host "Workspace: "
    Write-Host $workspace.Name
    

    ForEach ($dataset in (Get-PowerBIDataset -WorkspaceId $workspace.Id))

        {
		ForEach ($ds in (Get-PowerBIDatasource -DatasetId $dataset.Id -Scope Organization))
			{
        			[pscustomobject]@{

            			WorkspaceName = $Workspace.Name

            			WorkspaceID = $workspace.Id

            			DatasetName = $dataset.Name

            			DatasetID = $dataset.Id

					DatasourceName = $ds.Name
				}

            	}

        }

    }

   $Dir = "C:\pbi_test.csv"

   $DataSets | Export-Csv $Dir -NoTypeInformation -Encoding UTF8

   Write-Host "File created in " $Dir

   Disconnect-PowerBIServiceAccount

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi TCavins ,

     

    As far as I know, Datasource Name should be in -Name part. It should look like-Name DatasoureName.

     

    Get-PowerBIDatasource
       -Dataset <Dataset>
       [-WorkspaceId <Guid>]
       -Name <String>
       [-Scope <PowerBIUserScope>]
       [<CommonParameters>]

     

    For reference: Get-PowerBIDatasource

     

    Best Regards,
    Rico Zhou

     

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

    • TCavins's avatar
      TCavins
      Helper V

      Anonymous 


      Thanks. I'm trying to return the dataset name or the source name of the dataset. From my understanding, the -Name is used for when you know the name and want to return records with a datasource of that name.

       

      I don't know the names and we are trying to programmatically return all reports with their datasets/sources that are used in them so we can analyze it from there.

  • momo_man's avatar
    momo_man
    Frequent Visitor

    did you ever solve it. I am actually having the same issue