Data loss when uploading excel to power BI

[priyanka3]

Hi,

I am very new to Power BI and mainly a user so far. I am trying to import excel into power bi and while my actual file has approx. 99000 rows, only 44999 are read into the power BI. I have three excel files that I want to combine, and two of the three are not read in completely. I am unable to figure out the error. The format is exactly the same and there are no filters. Any help is very appreciated. Thanks. 

[priyanka3 · Accepted solution]

Ok it was pretty simple, though a bit non-intuitive. I formatted my data as a table in excel and voila!