Connect to Azure SQL from Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1879022%22%20slang%3D%22en-US%22%3EConnect%20to%20Azure%20SQL%20from%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1879022%22%20slang%3D%22en-US%22%3E%3CP%3ESo%20I'm%20using%20Excel%20365%20and%20trying%20to%20connect%20to%20an%20Azure%20SQL%20database.%26nbsp%3B%20The%20instruction%20say%20I%20should%20have%20a%20'From%20Azure%20SQL%20Database'%20under%20get%20data%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22milambert_0-1605145939081.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F233087i626870F10B51CBCA%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22milambert_0-1605145939081.png%22%20alt%3D%22milambert_0-1605145939081.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EBut%20all%20I%20have%20under%20'From%20Azure'%20is%20'From%20Azure%20Data%20Explore'.%26nbsp%3B%20I'm%20I%20missing%20something%3F%3C%2FP%3E%3CP%3EMike%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1879022%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1881138%22%20slang%3D%22en-US%22%3ERe%3A%20Connect%20to%20Azure%20SQL%20from%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1881138%22%20slang%3D%22en-US%22%3ETake%20a%20look%20at%20this%20where%20you%20can%20see%20which%20version%20of%20Excel%20have%20this%20included%3A%20%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fwhere-is-get-transform-power-query-e9332067-8e49-46fc-97ff-f2e1bfa0cb16%3Fui%3Den-us%26amp%3Brs%3Den-us%26amp%3Bad%3Dus%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fwhere-is-get-transform-power-query-e9332067-8e49-46fc-97ff-f2e1bfa0cb16%3Fui%3Den-us%26amp%3Brs%3Den-us%26amp%3Bad%3Dus%3C%2FA%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

So I'm using Excel 365 and trying to connect to an Azure SQL database.  The instruction say I should have a 'From Azure SQL Database' under get data:

milambert_0-1605145939081.png

But all I have under 'From Azure' is 'From Azure Data Explore'.  I'm I missing something?

Mike

 

1 Reply
Highlighted
Take a look at this where you can see which version of Excel have this included: https://support.microsoft.com/en-us/office/where-is-get-transform-power-query-e9332067-8e49-46fc-97f...