Try the latest Power Query update!

Try the latest Power Query update!

Rate This
  • Comments 9

Last month we announced the General Availability of Microsoft Power Query for Excel, and today we are excited to introduce a new quality update. Power Query is supported for your production scenarios and we will continue to deliver updates that provide added stability and performance benefits as we find any issues. Note that quality updates do not contain new features.

Power Query quality update (Download)

In this quality update for the Generally Available release of Power Query (OK to use in production scenarios), we’ve made the following quality fixes:

  • Improved error in the case where a query is trying to connect to a non-existent file.
  • Implemented more robust protection against out of memory issues when loading data into the workbook.
  • Improved experience for disabling online search in restricted markets.
  • A few other non-user facing bugs were fixed too.

You can download this update from this location. As always, please send us a note via smile/frown or our Forum in case you hit any issues with the update or usage of the product, and we will be more than happy to help you.


  • HI Miguel!

    Should we expect this update appearing in the Update button too?

    I see it's still not enabled now.

  • Hi Marco,

    Good catch! We will enable the Update button early next week, but most likely will take users to this blog post. :)



  • Is this version 1.5.3296.2082?

    I try to use Table.Pivot and always return error like "is it spelling correctly?".

  • What's the timing on powerbi preview for o365.  I have a session on it in 2 weeks at sharepoint Saturday because the announcement said late summer.  Any update on timing?

  • The power query update is not getting installed.It stays a dll required for installation is missing and asks to contact the administrator.I am using MS Excel Professional plus 64 bit version.

  • Still get Query Failed - "out of memory" errors trying to load a .csv file into PowerPivot 2013 Data Model, but using "From Other Sources" input directly from PowerPivot completes successfully.

    Any ideas?

  • Hello - I am running a PowerQuery, and I get all the right messages (I.e. Number of rows loaded and date of the data refresh). However, when I look at the data in the Excel Sheet itself, it is all out-of-date. I tried deleting all the rows and refreshing again, and the rows remained empty. It seems that the data is being updated but is not being displayed in the Excel Window. Any ideas as to why this is happening? Many thanks for this!

  • I updated to PowerQuery_2.14.3722.242 (64-bit) [en-US].msi and there is a major problem with it for our organization. It truncates data from cells with a large amount of characters in them. I was scrambling to resolve the issue to get some reports out so I didn't have a chance to see roughly how many characters it pulled in before it cut the data off. Users of large amounts of data beware. I had to restore my computer to the previous version to correct the issue.

  • I suddenly observed that Power Query and Power View tabs are missing from my Excel. Don't know the reason for this, but when I tried to reinstall it says "The feature you are trying to use in on a network resource that is unavailable... enter alternate path to a folder containing the installation package "PowerQuery_2.10.3598.81 (32-bit) [en-US].msi

    Old version of Microsoft Power Query for Excel cannot be removed.

    Can you please help me with this error?

Page 1 of 1 (9 items)

Comments in this blog are open and monitored for each post for a period of one week after the posting date. If you have a specific question about a blog post that is older than one week, please submit your question via our Twitter handle @MSPowerBI