Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
Anonymous
Not applicable

What is best way to export data from Power BI dataflow table to CSV file in SharePoint?

Hi All,

 

I have Power BI dataflows (with scheduled refreshes) on my Power BI services. I want to export data from the tables of these dataflows to csv files. These csv files reside in SharePoint. This activity should happen on weekly basis.

 

What is the best solution for it ? We have been trying couple of things like creating new dataset from dataflow in import mode and adding R/Python script to do this job. But I feel it's not optimal.

 

Thank you in advance!

 

Regards,

Jyoti

8 REPLIES 8
NandanHegde
Super User
Super User

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...




----------------------------------------------------------------------------------------------
Nandan Hegde (MSFT Data MVP)
LinkedIn Profile : www.linkedin.com/in/nandan-hegde-4a195a66
GitHUB Profile : https://github.com/NandanHegde15
Twitter Profile : @nandan_hegde15
MSFT MVP Profile : https://mvp.microsoft.com/en-US/MVP/profile/8977819f-95fb-ed11-8f6d-000d3a560942
Topmate : https://topmate.io/nandan_hegde
Blog :https://datasharkx.wordpress.com
valdano_34
Frequent Visitor

Have you tried paginated reports - you can build a dataset from the dataflow and then a paginated report on top of the dataset that can be exported to a .csv from within power automate - there are several hops indeed but that is the solution which I'm currently using which ironically I was looking for ways to optimize that brought me into this discussion : )

Hello Valdano

I am interested in that solution 
could you please describe in a few steps what steps you use in PA (Power Automate} to manage this output

Hi DjpejsenL,

 

Once you publish the paginated report, you can use one of the predefined PA templates to save the file to a locaiton - these are the 3 standard templates that are showning for me - pls. see the attached image.PA paginated.jpg

lbendlin
Super User
Super User

Why ?!?

 

Somebody on the forum decoded the way that dataflow CSVs* are stored in the Azure cloud, and pulled these via Power Automate (I think).  But for regular users dataflows cannot be accessed directly. You need to use a dataset to connect to the dataflow, and then you can run DAX or XMLA queries against that dataset (as you seem to be doing)  but that's highly inefficient.

 

It may be easier to talk to the people who fill the dataflows, and ask them for the souce data instead. Who knows, their source data may already be in CSV format.

 

*) Yes, dataflows are CSV files!!!

Anonymous
Not applicable

Thank you Ibendlin for your reply, but dataflow is created with different sources and those are not in CSV format.

I am still trying to find the solution. Currently we are using R script to export to excel that just works fine on desktop version but not working on Power Bi services. In the older community posts I read that this is not possible due to security reasons on Power Bi services, not sure if that's still the case.

 

Regards,

Jyoti

Dataflows are now an available connector in the GA Excel versions. You can write power query from within the excel workbook, and retrieve like any other data source query. Using excel as the vehicle introduces excel's limits.

If you can access the dataflow, you should be able to build a dataset. I also have had success consuming dataflow data via a published datasets using DAX / XMLA as suggested above

I would still suggest you find a solution outside of PowerBI. PowerShell, for example.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.