Forum Discussion
Export data from Power BI report to Azure SQL
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!!!
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.
2 Replies
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.Hopefully, this provides a new idea on how you can tackle your challenge.
Regards,
Tom
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.
