Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
simontaylor
Microsoft Employee
Microsoft Employee

export data from dataflow to sql azure database

‎01-03-2023 07:46 PM

Hi Power BI experts,

 

I am currently having a trouble to export data from power bi dataflow to azure sql database. Is there a way to do it?

 

Thanks,

Simon

Labels:
Message 1 of 3
1,552 Views
0
2 ACCEPTED SOLUTIONS
NandanHegde
Super User
Super User

‎01-03-2023 09:05 PM

Based on my understanding, there is no REST API for dataflow data extraction directly but there is one for Dataset.

So you need to create a dataset mapping to the dataflow and can extract the data . Please refer the below thread for data extractions from dataset:

 

https://community.powerbi.com/t5/Developer/Extract-data-from-PowerBi-into-csv-file-in-automated-way/...




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

View solution in original post

Message 2 of 3
1,505 Views
0
simontaylor
Microsoft Employee
Microsoft Employee

‎01-05-2023 09:22 AM

Thank you. I am asking the provider team to grant me Kusto or DB access now. Dataflow is not the one I need to work on. I have a traditional way to export data using python script to do a dataset refresh to achieve that goal.

View solution in original post

Message 3 of 3
1,464 Views
0
2 REPLIES 2
simontaylor
Microsoft Employee
Microsoft Employee

‎01-05-2023 09:22 AM

Thank you. I am asking the provider team to grant me Kusto or DB access now. Dataflow is not the one I need to work on. I have a traditional way to export data using python script to do a dataset refresh to achieve that goal.

Message 3 of 3
1,465 Views
0
NandanHegde
Super User
Super User

‎01-03-2023 09:05 PM

Based on my understanding, there is no REST API for dataflow data extraction directly but there is one for Dataset.

So you need to create a dataset mapping to the dataflow and can extract the data . Please refer the below thread for data extractions from dataset:

 

https://community.powerbi.com/t5/Developer/Extract-data-from-PowerBi-into-csv-file-in-automated-way/...




----------------------------------------------------------------------------------------------
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
Message 2 of 3
1,506 Views
0

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

View All