Power BI data tab issue

[Masoud_]

Hi, everyone,

The data tab in the desktop version of power bi, which is below the report tab, added 50,000 empty rows to every query I have except one!

Everything is just fine in the power query, and there are no blanks in any queries! How is that possible?

I checked everything, over and over but found no clue.

please help me out here.

Kind Regards,

Masoud

[HotChilli · Accepted solution]

Possibly, you don't see the blanks in Power Query because you are only looking at 1000 rows in the Preview.  

You can load the rest of the data to see if there are blanks/spaces by clicking on the bottom left of the screen where it shows 'Preview 1000 rows' (something like that, I'm not looking at it right now)