Help - Some rows aren't loaded to Query from the Excel Source!

[Anonymous]

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,

[v-xuding-msft]

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.

[Anonymous]

Thanks for your reply.

I had used the sheet as a data source and not the table.

That was my problem.

[v-xuding-msft]

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.