Forum Discussion
priyanka3
8 years agoFrequent Visitor
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
- priyanka3Frequent Visitor
Ok it was pretty simple, though a bit non-intuitive. I formatted my data as a table in excel and voila!