Forum Discussion

v-agutta's avatar
v-agutta
Microsoft Employee
5 years ago
Solved

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!!!
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    5 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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.