Forum Discussion

Powerbyte's avatar
Powerbyte
Frequent Visitor
4 years ago

Power Query data has less rows than data table

Today I ran into something I've never seen before and should not be possible. I'm wondering if anyone else has seen this as well. I had a PBIX file in import mode with a single table drawing from an ...
Need Help
TomMartens's avatar
TomMartens
Super User
4 years ago

Hey Powerbyte ,

 

I never encountered that Power BI remembers things, that are not there.

 

Maybe here
" ... 
I cleaned out the SQL data so that there was only 4 items left that started with CW. When I looked in the published Power BI file it was still showing all hundreds of rows even after a refresh (in workspace and app). 
..."

... you changed the Power BI Desktop file, but did not publish again?

 

Sometimes this happens to

  • changing the Power BI Desktop without publishing --> workspace content and app are not affected by the changes
  • publishing to the workspace but not updating the app --> app content is still not affected by the changes

Maybe one of the two things happened here as well?

Nevertheless, glad you have been able to fix this strange thing.

 

Regards,

Tom

 

May be

Powerbyte's avatar
Powerbyte
Frequent Visitor
4 years ago

Thanks for your reply Tom, yes that's correct I had not published the file again because the data was showing as incorrect in the actual PBIX file and I didn't want to publish invalid data. The fault seems to have been from within the PBIX file somehow.