Forum Discussion

Copper Contributor

Jun 07, 2021

Solved

Query Compatibility Issue

Hi there! I am in a situation wherein I have created an excel file with approximately 50 queries(with data connection to 4 different folders). The problem is, I tried to zip this file, and sent it to...

excel

SergeiBaklan
Jun 08, 2021
YashWani

Warning itself only says you may have errors (and you have it) due to incompatibility, that's not the source of the error. You need to check on 2016 concrete quires to see there the errors are.

SergeiBaklan

Diamond Contributor

Jun 08, 2021

YashWani

Warning itself only says you may have errors (and you have it) due to incompatibility, that's not the source of the error. You need to check on 2016 concrete quires to see there the errors are.

YashWani

Copper Contributor

Jun 12, 2021

Thanks Sergie, I checked the queries in the power querie window and found an error with a particular command(int64.type in index column) which was creating an error. Thanks for the help!

SergeiBaklan
Diamond Contributor
Jun 12, 2021
YashWani

Yes, 4th explicit parameter in Table.AddIndexColumn was added about an year ago and it is not supported by previous versions of Power Query. That's one of compatibility issues.

If you work with people who are on outdated Power Query you may manually remove this 4th parameter in formula bar, it's optional. Bit annoying, but the only other variant if your users will do the same on their machines.

Have a nice weekend.