Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
s2online
Regular Visitor

Powershell Get-PowerBIDataflowDatasource Not Returning Data Source Folder Path

 

 

 

 

How can I retrieve the Path property in Powershell for a File or Folder data source? Get-PowerBIDataflowDatasource is not returning the Path property.

The code below shows that Database, Server and Url properties are being returned, but no Path property.

 

 

 

 

$FlowDataSources = Get-PowerBIDataflowDatasource -DataflowId xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx -Scope Organization

ForEach($datasource in $FlowDataSources) {
    write-host $datasource.DatasourceType
    get-member -inputobject $datasource.connectiondetails | format-table
    }

 

 

 

 

Result (note Folder type but Path property missing):

 

 

 

 

Folder
   TypeName: Microsoft.PowerBI.Common.Api.Shared.DatasourceConnectionDetails

Name        MemberType Definition                    
----        ---------- ----------                    
Equals      Method     bool Equals(System.Object obj)
GetHashCode Method     int GetHashCode()             
GetType     Method     type GetType()                
ToString    Method     string ToString()             
Database    Property   string Database {get;set;}    
Server      Property   string Server {get;set;}      
Url         Property   string Url {get;set;}      

 

 

 

 

 

I know the Path property is set for the data source because I can see it if I call REST directly:

 

 

 

 

invoke-PowerBIRestMethod -Method Get -Url "/groups/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/dataflows/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/datasources" -Verbose

 

 

 

 

Result shows the Path property in the JSON:

 

 

 

 

{
  "@odata.context":"http://wabi-australia-east-a-primary-redirect.analysis.windows.net/v1.0/myorg/groups/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/$metadata#datasources","value":[
    {
      "datasourceType":"Folder","connectionDetails":{
        "path":"\\\\xxx\\xxx\\xxx"
      },"datasourceId":"xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx","gatewayId":"xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx"
    }
  ]
}

 

 

 

 

 

0 REPLIES 0

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.