Forum Discussion

paris's avatar
paris
Helper V
7 years ago

Get data from excel file , some data is empty

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 c...
Need Help
v-lili6-msft's avatar
v-lili6-msft
Community Support
7 years ago

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