Export data from Power BI report to Azure SQL

[v-agutta]

Hi, I need to export data from power Bi visuals to Azure SQL tables. Could anyone please help me on this how can i do this?

Thanks in advance!!!

[Anonymous · Accepted solution]

Hi @v-agutta 

You cannot directly export data from visual to Azure SQL DB. But I found a method that may help you .

As everyone knows , the format of the exported data from visual is xlsx or csv , so we can export the excel from Power BI visual and then import the excel to Azure SQL DB .There is a video that introduce how to connect to Azure SQL by SQL Server and then import the excel to SQL Server DB . I think this is a great operation, you can try it .

https://www.youtube.com/watch?v=o-lsjPG7QXE

Best Regards

Community Support Team _ Ailsa Tao

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

[TomMartens]

Hey @v-agutta ,

the simple answer is - you can't. Basically it's only possible to to export data from a visual as xlsx or csv.
You might can use the Power Automate visual that allows to pass a data to a flow, then this flow can do what ever you want with the data, also store the data into a SQL table.

https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-automate-visual#:~:text=When%20you...

Hopefully, this provides a new idea on how you can tackle your challenge.

Regards,

Tom