Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I added some information to my excel data. And when I opened the power BI and refresh the data, the Power BI is not reading the last 10 lines of my Excel.
all date in the excel are in the range of EXCel my sheet is 717 row and when refresh tha powerBi just loaded 707
i deleted data from the excel and still not reading last 10 rows
Hi, @Myoussif12
Please check if there are blank rows above the last 10 rows, if there are blank rows, it cannot be recognized as a table
Hope this helps.
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Myoussif12 ,
If your excel is formatted as a table,please make sure that all rows are inside the table. Also, try to refresh the data in the power query, and clear all filters.
Yes, all data are in the same table and also i tried to put some dummy rows, but still the same issue
@Myoussif12 , open power query and check, it might be showing some error
refer if needed
debug issue
https://www.youtube.com/watch?v=OE6DPmKqN7s
refer how to handle error in power query
https://www.youtube.com/watch?v=OE6DPmKqN7s
https://www.youtube.com/watch?v=9-Lag0VOiTs
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |