How to export the azure database data to excel from azure portal, Azure query editor does not have export option like to excel. If that is not possible what are the ways I can export the data using azure connect?
Add a comment
|
1 Answer
You can do this directly in Excel using the "Data Connection Wizard".
- Go to "Data" tab in your excel workbook
- In the data connection wizard enter connection details for your database server
Notice that server name has .database.windows.net in the end to provide full name.
- Select one or more tables to get data from
It's pretty intuitive from here on..
On a sidenote, for your client (machine where you're running Excel) to be able to connect to SQL Server, you may need to add the client's IP address following below steps -
Navigate to your Azure SQL Server in Azure Portal
Under Security, select "Firewalls and virtual networks"
- Add your client IP to the list of allowed IP Addresses here -
You can find your public facing client IP address by simply typing "my ip address" in google.
6 Comments
Rohit Saigal
@Ashwini Jha, were you able to get data into Excel using steps mentioned? or still facing any issues?
Ashwini Jha
How to connect if I am behind a firewall, which is blocking the port at 1433? Any web interface to connect to azure database?
Ashwini Jha
no I am unable to get the data, I guess network is blocking the default port which is 1433/1434, Any idea ?
Rohit Saigal
It may be a problem that Azure SQL Server isn't allowing connections to your client. Is your client machine (one where you have excel) IP address added to Azure SQL Server Firewall? If not, you need to add it or you can use a different machine that is already added to SQL server. I'll add the steps related to firewall access in answer above.
Rohit Saigal
@Ashwini Jha Were you able to connect to Azure SQL Server after following the new steps mentioned?
|