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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Sowmiya
Helper III
Helper III

Query Data

Hi Community,
Please assist me with exporting the Query Data from Power BI to Local Host MySQL.

Thanks in advance,
Ambhika

1 ACCEPTED SOLUTION

Hi @Nolock ,
I tried Connecting using this link: https://www.biinsight.com/exporting-power-bi-data-to-sql-server/ 
and it works. Thanks for your quick response.

View solution in original post

2 REPLIES 2
Nolock
Resident Rockstar
Resident Rockstar

Hi @Sowmiya,

check the following link: https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data

You can export data from a visual into a csv file and then import this file into MySQL.

If you have too many rows, there is another way how to do that: https://numidiabi.wordpress.com/2019/06/16/power-bi-performance-analyzer-pane-to-export-all-data-of-...

Hi @Nolock ,
I tried Connecting using this link: https://www.biinsight.com/exporting-power-bi-data-to-sql-server/ 
and it works. Thanks for your quick response.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

AugPowerBI_Carousel

Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

August Carousel

Fabric Community Update - August 2024

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

Top Solution Authors
Top Kudoed Authors