Expression.Error: There weren't enough elements in the enumeration to complete the operation.

[alyssahartigan]

I'm running into this error message for one of my tabs in Power BI. I've read other articles, but I don't even know what a pivot is, so I'm assuming that's not the issue. My spreadsheet is just data entry with a few columns that have formulas. For some reason, my power BI is capturing rows 1-88 correctly, but not recognizing 88-120. Any ideas? Everything else is working perfectly and correctly, it's just that it stops capturing data in the middle of the spreadsheet which is the weird part.

[v-qiuyu-msft]

Hi @alyssahartigan,

Does the issue happens in Power BI desktop or service? Would you please share a pbix file to clarify the issue? Do remove sensitive data before sharing with us. 

Best Regards,
Qiuyun Yu 

[alyssahartigan]

The issue is happening on Desktop! How do I share the file/ who do I send it too?

[alyssahartigan]

HI! I commented back on 5-21 but haven't heard a response yet. Who do I send the file to?

[alyssahartigan]

 @v-qiuyu-msft

[alyssahartigan]

@Vicky_Song @v-qiuyu-msft hi! who can i send the file to for help and review? thanks!

[alyssahartigan]

@Vicky_Song @v-qiuyu-msft can someone please advise how to proceed? thanks!

[alyssahartigan]

@Vicky_Song @v-qiuyu-msft Is there anyone who can advise how to proceed? Thanks.