Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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"
}
]
}
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.