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"
}
]
}
User | Count |
---|---|
47 | |
32 | |
30 | |
27 | |
26 |
User | Count |
---|---|
56 | |
55 | |
36 | |
33 | |
28 |