Forum Discussion
MicrosoftPowerBIMgmt and Gen2 Dataflows
Would be I be right in thinking that Get-PowerBIDataflow does not support Gen2 Dataflows? Any alternatives for managing via PowerShell?
Thanks...
Hi Anonymous ,
You're absolutely right — as of now, Get-PowerBIDataflow from the MicrosoftPowerBIMgmt module doesn’t support Gen2 Dataflows. It only works with classic (Gen1) dataflows.
For Gen2, there’s currently no direct PowerShell cmdlet available. But here are a couple of alternatives:
- REST API: You can use the Power BI REST API for Dataflows — specifically the Get Dataflow and Get Dataflow Transactions endpoints. These support Gen2.
- Service Principal + API calls: If you're managing at scale, consider using a service principal with delegated permissions to call the API programmatically.
- Fabric Admin Monitoring: For broader Gen2 monitoring, the Fabric Capacity Metrics app gives some visibility, though not as granular as PowerShell.
Hopefully Microsoft expands PowerShell support soon, but for now, REST API is your best bet.
If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.
1 Reply
Hi Anonymous ,
You're absolutely right — as of now, Get-PowerBIDataflow from the MicrosoftPowerBIMgmt module doesn’t support Gen2 Dataflows. It only works with classic (Gen1) dataflows.
For Gen2, there’s currently no direct PowerShell cmdlet available. But here are a couple of alternatives:
- REST API: You can use the Power BI REST API for Dataflows — specifically the Get Dataflow and Get Dataflow Transactions endpoints. These support Gen2.
- Service Principal + API calls: If you're managing at scale, consider using a service principal with delegated permissions to call the API programmatically.
- Fabric Admin Monitoring: For broader Gen2 monitoring, the Fabric Capacity Metrics app gives some visibility, though not as granular as PowerShell.
Hopefully Microsoft expands PowerShell support soon, but for now, REST API is your best bet.
If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.