Data Load Issue

[cyborgandy]

Hi All,

I am connecting my power bi to a share point folder which has excel file in it, after adding it I am getting more 200000 as a blank row, however these are not present in the actual excel file, previously I have connected the file and it was showing the same row count which was available in excel file .

Below is the snapshot for your refrence,

[Royel]

So that, while loading or after loading your data into power bi desktop, go to Transform Data / Power Query

select any column and uncheck the blank or null values. It will remove all blank values from loaded data. 

See the attached image 

Then click Close and Apply. 

Regards
Royel

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Royel]

@cyborgandy in your excel sheet you are out of data rows limit 

A single excel sheet can not contain more than 1,048,576 rows. However in this case, you can split your excel file into different sheets and after loading it into power bi do the append operation in there, power bi does not have such limitations. 

Regards
Royel

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[cyborgandy]

The actual rows are only 70000 this blank rows are getting created in power bi , i am not sure why this is happening, I am looking solution for that issue