Forum Discussion
Compatibility issue in Power Query
I have prepared one Power Query on my office desktop and when I am using the same file on my laptop (both have office 2016) it is showing below error. Tried so much and researched a lot but unable to...
SergeiBaklanCan't ignore the error as query is not working due to version issue and not able to update the query version. Working on a licensed version still not a single support from Microsoft.
1) "not working" is too abstract, perhaps some concrete step is not working. As variant, this summer to Table.AddIndex was added explicit 5th parameter (Int64.Type) which was not in previous versions. If so, you may safely remove it in formula bar. But that means you didn't update Excel for few months.
2) However, above is temporary solution, you need to have we latest Power Query. It can't be updated separately, entire Excel 2016 is to be updated. If you have same Excel 2016 build numbers you shall have the same Power Query versions.
- As per technical team of my office both (laptop & desktop) office versions are same. They have uninstalled and installed multiple times.