Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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"
}
]
}
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
50 | |
32 | |
27 | |
26 | |
25 |
User | Count |
---|---|
62 | |
49 | |
29 | |
24 | |
23 |