1

If I want to import data from Azure SQL Database to an Excel file I can easily go into

Data > Get Data > From Azure > From Azure SQL Database

and Power Query will take care of the REST (couldn't avoid the pun, sorry):

enter image description here

But then I want to do this with Excel online so the file could refresh daily and be available for my colleagues.

Luckily Microsoft provides a guide called: How to refresh data to a SQL Azure Database in Excel Online and guess what? I'm stuck in the very first step.

In fact the guide tells to go into

Data > From Other Sources > From Data Connection Wizard

But there is no such thing in Excel Online:

enter image description here

How to connect Excel Online to Azure SQL Database and pull data?

Improve this question
7
  • 1
    From the page you linked to step 13 says "Upload this workbook to Excel Online". That to me indicates you need to create it in your local install of excel. Commented Oct 5, 2023 at 14:26
  • I reported the documentation (the URL you shared with us) as outdated. Thisseems to be no possible anymore on Excel online. Commented Oct 5, 2023 at 16:39
  • Thank you @AlbertoMorillo, where can I report that? Commented Oct 5, 2023 at 17:31
  • I reported the issue here. github.com/MicrosoftDocs/microsoft-365-docs/issues/12908 Commented Oct 5, 2023 at 18:32
  • 1
    Usually Microsoft Docs have the "This page" button at the bottom of each page for you to report this type of issues. learn.microsoft.com/en-us/azure/azure-sql/database/…. But the page you shared with us does not have it. Commented Oct 5, 2023 at 18:36

1 Answer 1

Reset to default
1

As @Alberto Morillo said the document is an outdated and the options showed in document is not visible or supported in Excel online.

The doc you provided in that in last point they said you need to upload it in excel online by storing it in OneDrive.

To achieve your scenario, you need to first create excel and connect it to SQL database. and get the table the upload the excel to OneDrive.

enter image description here

and if you refresh the excel from local it will show changes in the excel online if you open it. enter image description here

Update:

You can enable auto refresh option for connection so it will get automatically refreshed as below.

Quires & Connections >> Connection Properties >> Last refreshed

enter image description here

Improve this answer
Sign up to request clarification or add additional context in comments.

3 Comments

Does it means that if I update the table in Azure SQL Database the change will be reflected into the Excel file? I don't think so because I cannot managed the refresh if it's hourly or daily
check the updated section.
Thank you @Pratick . I set the refresh to 1440 minutes. Does it means that if I go to holiday for 2 weeks nothing will refresh as I don't turn on my PC? Because I want this to be flowless. Maybe Power Automate or Logic App is a better approach?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.