topic Re: PowerShell export table of in Developer

PowerShell export table of

Anonymous — Mon, 11 Jul 2022 12:07:29 GMT

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

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!

Re: PowerShell export table of

Anonymous — Thu, 14 Jul 2022 09:59:02 GMT

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

Description	Module Name	Download
Export all dataflows from a workspace	ExportWorkspace.ps1	GitHub Location

REST API:

Dataflows - Get Dataflows

GET https://api.powerbi.com/v1.0/myorg/groups/{groupId}/dataflows

Best Regards

Re: PowerShell export table of

Hariharan_R — Fri, 15 Jul 2022 08:57:23 GMT

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

Re: PowerShell export table of

Anonymous — Wed, 12 Oct 2022 15:26:57 GMT

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?