Expanded Values Don't Match Values in Merged Table

[bigsky5829]

This is what is merged into my query:

And this is what happens after I expand the values.  They are completely different (and wrong!)

What could possibly be going on here?

[edhans · Accepted solution]

Try flushing the PQ cache, or force it to refresh. You can clear the cache in the Data Load settings. It might be expanding the correct values and showing you the incorrect ones.

If that isn't it, then @v-yingjl is correct. Share data. There is something else going on that isn't easy to reproduce. 

How to get good help fast. Help us help you.

How To Ask A Technical Question If you Really Want An Answer

How to Get Your Question Answered Quickly - Give us a good and concise explanation
How to provide sample data in the Power BI Forum - Provide data in a table format per the link, or share an Excel/CSV file via OneDrive, Dropbox, etc.. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables.

[bigsky5829]

I cleared the cache and I cannot reproduce the error any longer.  The data in the preview was correct; the expanded data is incorrect.  I have sanitized data and the M code I can post, but it appears just to be a caching issue.

[edhans]

Excellent @bigsky5829 - glad that was the issue. I rarely have to clear the cache, but it isn't never, so just remember that feature exists. Hope the rest of your project goes a bit smoother. 😁

[v-yingjl]

Hi @bigsky5829 ,

Could not reproduce it in my side. How would the rank column be created, a custom column or just in the table initially.

Could you please consider sharing a sample file or some sample data without ant sensitive information for further dsicussion so that memebers in the community could help you better.

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.