Excel 2016 Get Data From Azure not available

Copper Contributor

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?