Query Data

[Sowmiya]

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

Thanks in advance,
Ambhika

[Nolock]

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

[Sowmiya · 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.