Forum Discussion

MelStaunton's avatar
MelStaunton
Helper III
6 years ago
Solved

Numerical values changed from Power Query Editor to table view in Power BI Desktop!

 

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!

 

  • 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. 

3 Replies

  • 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's avatar
      MelStaunton
      Helper III

      Yes, I did refresh. This is also weekly data. So no continous update.

    • MelStaunton's avatar
      MelStaunton
      Helper III

      I think you were right. I just did another refresh and now data is right. Thanks!