Power Pivot for Excel 2010 – there are 2 Versions But Microsoft listened to the community and made an announcement that Power Pivot will be made available in “all” Windows editions (“SKUs”) of Excel starting from April 2018! However there are still exceptions with some of the Excel 2013 versions and boxed versions purchased prior to Office 2019.

One very common question people ask is “which versions of Excel come with Power Pivot”? Until recently not all Microsoft Office products included Power Pivot.

Relationships in Power BI and Power Pivot.

Who Needs Power Pivot, Power Query and Power BI Anyway?.

The Best Way to Install Power BI Desktop.

30 Reasons You Should Be Considering Power BI.

Dimensional Modeling (Excel and Power BI).

Power BI for the Business Analyst (with live Q&A).

Find the step that throws the error for Percentage.Type and change it to Number. Find the step that throws the error for Csv.Document and in the formula bar delete the part that goes, Columns = x If you can't do this (lean on IT, because they should have set it up that way to begin with), you would need to: That should bring you up to the current version of Power Query and solve all of your issues. Make sure the box for 'get updates for other Microsoft Products when I update Windows' is checked.

To do that, go to Windows -> Windows Update -> Advanced Options. The best thing to do here is actually get your Office version updated. Your issue doesn't have anything to do with 32 vs 64 bit, but rather that your 32 bit install had been updated to the latest Power Query version, and your 64 bit install is running the original (old and buggy) build of Power Query. You've moved from 32 bit Office 2016 to 64 bit Office 2016, is that correct?

Power query office 2016