Forum Discussion
Help - Some rows aren't loaded to Query from the Excel Source!
I have a source file which has 304 rows as shown below:
But the query shows just 301 rows -
Please help me with the possible reasons of the query not loading the last 3 rows.
Thanks,
3 Replies
- v-xuding-msft
Community Support
Hi Anonymous ,
I can't reproduce your issue. Can you please share a .xlsx file to let me test?
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- AnonymousNot applicable
Thanks for your reply.
I had used the sheet as a data source and not the table.
That was my problem.
- v-xuding-msft
Community Support
Hi Anonymous ,
I also tried to import sheets. But it worked fine in my sample. I think maybe you need to check if there is any irrational data so that Power BI can't recognize it.
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.