Forum Discussion

priyanka3's avatar
priyanka3
Frequent Visitor
8 years ago
Solved

Data loss when uploading excel to power BI

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. 

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

1 Reply

  • priyanka3's avatar
    priyanka3
    Frequent Visitor

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