Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I would like to export using PowerShell one table from one dataflow of a given workspace but I cannot find the command...
Using PowerQuery in PowerBI Desktop, this is as below
let
Source = PowerBI.Dataflows(null),
WS = Source{[workspaceId="b79b08df-8014-4efd-abed-..."]}[Data],
DF = WS{[dataflowId="c1579a50-583a-4dc9-9d96-..."]}[Data],
#"1TABLE" = DF{[entity="1TABLE]}[Data]
in
#"1TABLE"
In PowerShell, I can do the following
Login-PowerBIServiceAccount
Get-PowerBIWorkspace
Get-PowerBIDataflow -WorkspaceId b79b08df-8014-4efd-abed-...
and get as output two dataflows I have in this workspace
Id : c1579a50-583a-4dc9-9d96-...
Name : ONE
Description :
ModelUrl :
ConfiguredBy : my.name@company.com
Id : 380b63a3-15e4-4bc0-9d34-...
Name : TWO
Description :
ModelUrl :
ConfiguredBy : my.name@company.com
but now, I don't see how to export
I see Export-PowerBIDataflow -WorkspaceId <xx> -Id <yy> -OutFile out.json can export a dataflow but I need to export at entity level as in Power Query above
Any idea if this is feasible and how to make it using PowerShell?
note: I know how to export from PowerBI Desktop using R script or to export from PowerBI using PowerAutomate visual (with limitations) but I need to pull data from external
Thanks for your help!
Solved! Go to Solution.
Hi @stchln ,
You can refer the following links to get it.
Powershell:
Power BI dataflows PowerShell scripts on GitHub
Description Module Name Download Export all dataflows from a workspace ExportWorkspace.ps1 GitHub Location
REST API:
GET https://api.powerbi.com/v1.0/myorg/groups/{groupId}/dataflows
Best Regards
Hi @stchln
As per my understanding, you can't export the data from Power bI dataflow. The available rest API is export the dataflow script and import which just holds the metadata of the dataflow.
We have REST api to export the data from Power BI dataset ("Execute DAX script"). if you create dataset using your dataflow then you can export the data.
Thanks
Hari
Hi @stchln ,
You can refer the following links to get it.
Powershell:
Power BI dataflows PowerShell scripts on GitHub
Description Module Name Download Export all dataflows from a workspace ExportWorkspace.ps1 GitHub Location
REST API:
GET https://api.powerbi.com/v1.0/myorg/groups/{groupId}/dataflows
Best Regards
Hello yingyinr
Looking at powerbi-powershell/examples/dataflows/ExportWorkspace.ps1
Exports all the dataflow model.json from a Power BI workspace into a folder
Meaning structure can be exported but not the raw data, right?
User | Count |
---|---|
16 | |
5 | |
2 | |
1 | |
1 |
User | Count |
---|---|
22 | |
3 | |
3 | |
2 | |
1 |