Hi! I need help on the following: values change somehow between QUery editor and Desktop table.
I have correct values in Power Query editor, the two values highlighted change randomly when I "Close&Apply"
Any idea why this would happen?? I have similar other tables, none change values randomly.
Any help is greatly appreciated!
Solved! Go to Solution.
@MelStaunton
This may seem like a silly question, but have you refreshed the data recently? It's possible that the preview data in Power Query was refreshed after the data you see in your visuals.
@MelStaunton
This may seem like a silly question, but have you refreshed the data recently? It's possible that the preview data in Power Query was refreshed after the data you see in your visuals.
I think you were right. I just did another refresh and now data is right. Thanks!
Yes, I did refresh. This is also weekly data. So no continous update.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
User | Count |
---|---|
119 | |
75 | |
66 | |
51 | |
49 |
User | Count |
---|---|
183 | |
101 | |
80 | |
79 | |
77 |