Forum Discussion
Solved
Power BI data tab issue
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...
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)
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)