How to import data from Azure SQL Azure Database to Excel Online

admin

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?

Read more here: Source link