Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper V
Helper V

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 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,




Community Support
Community Support

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,




Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors