Compatibility issue in Power Query

%3CLINGO-SUB%20id%3D%22lingo-sub-1841033%22%20slang%3D%22en-US%22%3ECompatibility%20issue%20in%20Power%20Query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1841033%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20prepared%20one%20Power%20Query%20on%20my%20office%20desktop%20and%20when%20I%20am%20using%20the%20same%20file%20on%20my%20laptop%20(both%20have%20office%202016)%20it%20is%20showing%20below%20error.%20Tried%20so%20much%20and%20researched%20a%20lot%20but%20unable%20to%20find%20solution.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EError%20is%2C%20The%20Power%20Queries%20in%20this%20workbook%20might%20be%20incompatible%20with%20your%20current%20version%20of%20excel.%20These%20queries%20were%20authored%20with%20a%20newer%20version%20of%20Power%20Query%20and%20might%20not%20work%20in%20your%20current%20version.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1841033%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1841052%22%20slang%3D%22en-US%22%3ERe%3A%20Compatibility%20issue%20in%20Power%20Query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1841052%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F852831%22%20target%3D%22_blank%22%3E%40pankajbagora%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThis%20message%20always%20appears%20if%20opened%20file%20was%20edit%20on%20newer%20version%20of%20Power%20Query.%20You%20may%20ignore%20it%2C%20but%20better%20to%20update%20PQ%20up%20to%20latest%20version.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1841336%22%20slang%3D%22en-US%22%3ERe%3A%20Compatibility%20issue%20in%20Power%20Query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1841336%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F852831%22%20target%3D%22_blank%22%3E%40pankajbagora%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E1)%20%22%3CSPAN%3Enot%20working%22%20is%20too%20abstract%2C%20perhaps%20some%20concrete%20step%20is%20not%20working.%20As%20variant%2C%20this%20summer%20to%20Table.AddIndex%20was%20added%20explicit%205th%20parameter%20(Int64.Type)%20which%20was%20not%20in%20previous%20versions.%20If%20so%2C%20you%20may%20safely%20remove%20it%20in%20formula%20bar.%20But%20that%20means%20you%20didn't%20update%20Excel%20for%20few%20months.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3E2)%20However%2C%20above%20is%20temporary%20solution%2C%20you%20need%20to%20have%20we%20latest%20Power%20Query.%20It%20can't%20be%20updated%20separately%2C%20entire%20Excel%202016%20is%20to%20be%20updated.%20If%20you%20have%20same%20Excel%202016%20build%20numbers%20you%20shall%20have%20the%20same%20Power%20Query%20versions.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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 find solution. 

 

Error is, The Power Queries in this workbook might be incompatible with your current version of excel. These queries were authored with a newer version of Power Query and might not work in your current version.

5 Replies

@pankajbagora 

This message always appears if opened file was edit on newer version of Power Query. You may ignore it, but better to update PQ up to latest version.

@Sergei BaklanCan'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.

@pankajbagora 

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.

@pankajbagora 

Could you please share build numbers for both, they are in File->Account like

image.png