Home

Excel 2016 Get Data From Azure not available

%3CLINGO-SUB%20id%3D%22lingo-sub-146155%22%20slang%3D%22en-US%22%3EExcel%202016%20Get%20Data%20From%20Azure%20not%20available%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-146155%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20following%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fcodehollow.com%2F2016%2F10%2Fworking-with-azure-table-storage-and-excel%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ethis%20article%3C%2FA%3E%26nbsp%3Band%20%3CSTRONG%3EGet%20Data%20From%20Azure%3C%2FSTRONG%3E%20is%20not%20listed%20as%20an%20option%20for%20me.%26nbsp%3B%20I%20am%20running%20Excel%202016%20Build%208911.2016%20Business%20Premium.%26nbsp%3B%20What%20am%20I%20missing%3F%26nbsp%3B%20How%20can%20I%20import%20Azure%20storage%20tables%20into%20Excel.%26nbsp%3B%20Works%20fine%20in%20Microsoft%20Power%20BI%20Desktop.%26nbsp%3B%20%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-146155%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EGet%20%26amp%3B%20Transform%20Data%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ENeed%20Help%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-321282%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%202016%20Get%20Data%20From%20Azure%20not%20available%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-321282%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20business%20premium%20and%20I'm%20running%20into%20this.%20This%20seems%20pretty%20junky%20for%20MS%20to%20do.%20I%20have%20Sharepoint%2C%20and%20I%20can%20create%20a%20power%20query%20link%20through%20Sharepoint...%20but%20I%20can't%20create%20one%20from%20Excel%20and%20edit%20it%20properly.%20Who%20thought%20this%20was%20OK%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-149938%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%202016%20Get%20Data%20From%20Azure%20not%20available%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-149938%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Michael%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAdvanced%20analytical%20features%20are%20not%20part%20of%20Business%20Premium%20(e.g.%20you%20have%20no%20Power%20Pivot).%20Similar%20for%20PQ%20functionality%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%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.office.com%2Fen-us%2Farticle%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%2FP%3E%3C%2FLINGO-BODY%3E
Michael Patten
Occasional Visitor

I am following this article and Get Data From Azure is not listed as an option for me.  I am running Excel 2016 Build 8911.2016 Business Premium.  What am I missing?  How can I import Azure storage tables into Excel.  Works fine in Microsoft Power BI Desktop.   

2 Replies

Hi Michael,

 

Advanced analytical features are not part of Business Premium (e.g. you have no Power Pivot). Similar for PQ functionality https://support.office.com/en-us/article/Where-is-Get-Transform-Power-Query-e9332067-8e49-46fc-97ff-...

I have business premium and I'm running into this. This seems pretty junky for MS to do. I have Sharepoint, and I can create a power query link through Sharepoint... but I can't create one from Excel and edit it properly. Who thought this was OK?

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies