Forum Discussion
Excel 2016 Get Data From Azure not available
I am following https://codehollow.com/2016/10/working-with-azure-table-storage-and-excel/ 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
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?
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-f2e1bfa0cb16?ui=en-US&rs=en-US&ad=US
