How to import data from Azure SQL Azure Database to Excel Online
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):
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:
How to connect Excel Online to Azure SQL Database and pull data?
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.
and if you refresh the excel from local it will show changes in the excel online if you open it.
Update:
You can enable auto refresh option for connection so it will get automatically refreshed as below.
Quires & Connections >> Connection Properties >> Last refreshed
- Asp.net: - is a physical path, but a virtual path was expected
- Application.Match is not working correctly with dates in a VBA array
- VBA Option Buttons Clearing for Unknown Reason
- VBA for loop exercise with merged cells. How to get it right?
- Want to add suffix before file name extension with excel vba
- Write date in "dd/mm/yyyy" format
- Export to Excel head row format filter
- How to paste a whole array without looping through it in VBA?
- SendKeys to FileDialog
- INDEX MATCH Function Inconsistent
- Create Dynamic Named Range, based on adjacent value
- Visual Studio 2019 C++ dll Excel VBA addin Problems
- Formula not autofilling in excel table (VBA)
- Excel Macro, inserting internationally valid formula during run-time
- Copied cells does not always apear at the top av the pasted sheet
- How to get common data from a large data set sheet into a small data set sheet with common entry in first column and match them accordingly
- How do I create an Excel (.XLS and .XLSX) file in C# without installing Microsoft Office?
- How to keep leading zeroes when pasting into excel file?
- Reading date from .xlsx file returns 5 digit timestamp, what is this?
- Redim preserve array on recursive sub
- Forecast formula from Excel in JavaScript
- win32 ExportAsFixedFormat
- Blending Model: Oil Production
- Flatten Parent Child Hierarchy in Excel (using formula or VBA)
- How can I toggle the Focus Cell menu option from VBA?
- Excel VBA for-loop which checks if multiple ListBoxes have values
- Embedding graphics files and .pdfs into an excel spreadsheet
- Setting a workbook with user input
- Show single month and year in combobox in Excel VBA and show listbox value during change
- How can I avoid using Select in Excel VBA?