Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
95 | |
77 | |
65 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |