Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

More rows in Power Query than Data view

I am losing my mind, I've never seen this happen before.   I made some changes to the API enabled report my dataset is pulling from then refreshed the table in Power Query. The row count updated ac...
Need Help
  • BA_Pete's avatar
    BA_Pete
    3 years ago

    Hi Anonymous ,

     

    First, in Power Query, go to the Home tab and hit Refresh Preview. Check your row counts.

     

     

    If you don't have a match now then, in Desktop, go to the Home tab and hit refresh. Check your row counts.

     

     

    Let me know if you still have an issue after this and we can dig a bit deeper.

     

    Pete

BA_Pete's avatar
BA_Pete
Super User
3 years ago

Hi Anonymous ,

 

First, in Power Query, go to the Home tab and hit Refresh Preview. Check your row counts.

 

 

If you don't have a match now then, in Desktop, go to the Home tab and hit refresh. Check your row counts.

 

 

Let me know if you still have an issue after this and we can dig a bit deeper.

 

Pete

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Thanks so much! I'm not sure why it didn't occur to me to refresh the dataset. 

  • BA_Pete's avatar
    BA_Pete
    Super User
    3 years ago

     

    Easy one to miss.

    Everyone laughs at the old "Switch it off and back on again", but it's a meme for a reason! ğŸ˜‚

     

    Pete