Get data from excel file , some data is empty

[paris]

Hi All,

I like to import a sheet from excel by using Get data function.

The sheet has a list of 87,660 rows. Values are taken from another sheet in the same exel file by using sumproduct calculation.

When I import it, some of value data (not all of them) is missing , just empty , zero. 

Can you think of possible cause of this problem?

All the best,

Paris

[v-lili6-msft]

hi, @paris

Your description is a little confused, Could you share us some screenshots for more details? 

And in Edit Queries, you couldn't all the data, but in the data view you will see all the data.

And maybe you need to have a reference to this article:

Power BI Get Data From Excel: Everything You Need to Know

Best Regards,

Lin