Log In
Register
Home
Active Member
August 20, 2021
Offline
Hi I have unusual error in my pq
It is very big file, many sources -
When i refresh all queries / very often one / more than one column have null rows, (some rows ok, some null), .
but in Power Query Editor there is everything ok, all data is ok.
But in excel there are null.
Do You have any ideas why i Have this problem?
VIP
Trusted Members
December 7, 2016
Offline
Hello,
Do you get null when refreshing one query at a time instead of all at the same time?
Br,
Anders
Active Member
August 20, 2021
Offline
When I am refreshing all queries.
VIP
Trusted Members
December 7, 2016
Offline
Hello,
If it works fine when refreshing one query at the time then I can only assume nothing is wrong with the queries. Might be that you've got an issue with the cache in Power Query. Have you tried to empty the cache?
Br,
Anders
Active Member
August 20, 2021
Offline
I cleared the cache, raised the RAM limit. did not help
VIP
Trusted Members
December 7, 2016
Offline
Well, I am soon out of suggestions. Do you get any alert message in the Queries and Connections view for those queries showing null values? If so, what does it say?
1 Guest(s)
