Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
Ok it was pretty simple, though a bit non-intuitive. I formatted my data as a table in excel and voila!
Ok it was pretty simple, though a bit non-intuitive. I formatted my data as a table in excel and voila!