Forum Discussion
PowerShell export table of
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 : [email protected]
Id : 380b63a3-15e4-4bc0-9d34-...
Name : TWO
Description :
ModelUrl :
ConfiguredBy : [email protected]
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!
Hi Anonymous ,
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}/dataflowsBest Regards
3 Replies
Hi Anonymous ,
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}/dataflowsBest 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?
Hi Anonymous
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
Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.
My Blog :: YouTube Channel :: My Linkedin
