Forum Discussion

GStout824's avatar
GStout824
Frequent Visitor
2 years ago
Solved

Power Query vertical row preview shows different records than record selected

Hi all.  I have scoured the internet for hours looking for a resolution, and I am officially stumped.  I don't even know how to search this to get meaningful right results.  Anyway...

 

Inside PQ, when I click on a row to bring up the vertical preview of that record's values in the table, it's returning the values of a completely different record.  (See attached photo.)  I've tried refreshing the data, but nothing seems to work.

 

Anyone have any idea what this is about, and how to fix it?  Totally lost.

 

Many thanks in advance for any assistance.

G

 

  • Anonymous's avatar
    Anonymous
    2 years ago

    Try clearing the cache in the settings/data section.

     

    --Nate

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Try clearing the cache in the settings/data section.

     

    --Nate

    • GStout824's avatar
      GStout824
      Frequent Visitor

      Wow, thanks so much Nate.  That worked.  I'm sure that's a 'Day 1' problem for many, but I had no idea.  Thanks again, truly appreciated.