Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
MaxPowerBI92
New Member

Different number of rows between PowerQuery Editor and Data view

Hi all,

 

i'm certainly have an issue in PowerBI. In the query editor i have an Table with 450 rows. When i click "save and apply" and load the data, the data perfectly loads with no error message or something. But: the same table comes out with only 200 rows. There is no filter or anything. Can someone explain this?

 

Now it's getting interesting: I added a new step in the query editor and then reload the data. The result was that i got all 450 rows. So i updated the data modell in powerBI online and activated the automatic refresh. After the next refresh the table again only have 200 rows. I have no clue..

 

Thank you for any idea!

1 REPLY 1
PhilipTreacy
Super User
Super User

Hi @MaxPowerBI92 

 

Please post your data and the queries you are using.

 

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors