1

I have installed Power Query to access an azure SQL database. However I don't see a 'From azure' button which seems to appear in the screen shots in the tutorials. How can I activate this? Is there something else I need to install?

enter image description here

I am trying to follow the instructions here:

https://support.office.com/en-ie/article/Introduction-to-Microsoft-Power-Query-for-Excel-6e92e2f4-2079-4e1f-bad5-89f6269cd605

On this page the screen shot at the top does not have the 'From azure' button but the video further down the page does. Is there some magic way to get it to appear?

  • Please edit your question and add a screenshot of your Excel window (with the missing button), and also include a link to the tutorial you're trying to follow. – Ƭᴇcʜιᴇ007 Sep 22 '15 at 15:24
  • How do I post a screen shot here? – Rachel Edge Sep 22 '15 at 15:26
  • Post it on a publically accessible image host (ie: imgur.com) and then edit and include a link to it in your question. You currently don't have enough rep to post an actual screenshot, but one of the higher-rep users can and will edit it for you to make it an actual in-line picture. :) – Ƭᴇcʜιᴇ007 Sep 22 '15 at 15:28
  • I tried to post another link as well but don't have enough reputation to do so! – Rachel Edge Sep 22 '15 at 16:42
  • Which version of Power Query are you using? – Ƭᴇcʜιᴇ007 Sep 22 '15 at 16:48
2

From the Power Query 2.26.4128.242 release notes:

The following Office versions are supported:

Microsoft Office 2013:

  • Power Query Premium:

    • Features Included: All.
    • SKUs supported: Professional Plus, Office 365 ProPlus or Excel 2013 Standalone.
  • Power Query Public:

    • Features included: All, except the following connectors: Corporate Power BI Data Catalog, Azure-based data sources, Active Directory, HDFS, SharePoint Lists, Oracle, DB2, MySQL, PostgreSQL, Sybase, Teradata, Exchange, Dynamics CRM, SAP BusinessObjects, Salesforce.
    • SKUs supported: All Desktop SKUs.

So, unless you are running "Office 2013 Professional Plus", "Office 365 ProPlus", or "Excel 2013 Standalone", the PQ installer will install the "Public" version of Power Query, and you will not be able to use the Azure connectors.

  • Thanks. It would be helpful if that was noted on the page I referenced above and on this one: support.office.com/en-ie/article/…. Both don't mention any restrictions on versions of Excel! I've added a comment about that on both pages. – Rachel Edge Sep 22 '15 at 21:22

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.