Forum Discussion
YashWani
Jun 07, 2021Copper Contributor
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...
- Jun 08, 2021
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
Jun 07, 2021Diamond Contributor
That's not an error, that's the warning which says PQ was on more modern version of it. It appears on different versions of 365 as well if PQ was created on newest build.
Just Close it and continue to work. However, there is some probability that incompatibility errors with 2016 could appear, but that will be errors within concrete queries. If any.
- YashWaniJun 08, 2021Copper ContributorThanks for replying Sergei, the problem here being that the queries ae not refreshing because of this particular warning. I am getting a "failed to refresh data range error" for all the queries.
- SergeiBaklanJun 08, 2021Diamond Contributor
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.
- YashWaniJun 12, 2021Copper ContributorThanks 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!