Export Dataflow data to external application

[sanderpolman]

Hi all,

I want to use the data from one or more dataflows/datasets (customer information) as a source for an external application. Is this possible? For example, an export to .csv or something on a scheduled basis would be nice.

- I tried using MS Flow (I tried but Power BI integration is limited)

- I tried this https://www.thebiccountant.com/2019/04/01/export-data-from-power-bi-using-microsoft-flow/ but it requires a Premium Flow account and it's quite a work around

Hope someone can help!

Best regards, Sander

[NandanHegde]

Hey,

Now one can extract data from PowerBI dataflow via MSFT Fabric dataflow gen2 .

https://datasharkx.wordpress.com/2023/11/02/automated-way-to-extract-data-from-power-bi-dataflow-via...

[v-xuding-msft · Accepted solution]

Hi @sanderpolman ,

As I know, you could use the feature of Analyze in Excel to export data for datasets. And I searched two blogs that you can reference.

Export Power BI DataSet to Excel

Export datasets from Power BI Service to CSV using VBA

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.