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?
Hello,
Do you get null when refreshing one query at a time instead of all at the same time?
Br,
Anders
When I am refreshing all queries.
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
I cleared the cache, raised the RAM limit. did not help
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?
I had to create a new account
Nope. There isn't any errors. any alerts.
Thats why i have no idea what's problem.
Very rare bug?
It is very big query, lot of connections and merges in one.
