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

Problem:

Reason: someone activated filter in .xls file so excel subsheet “FilterDatabase” was created that gives error values.

Solution: Filter sheets which ends with “FilterDatabase”
= Table.SelectRows(#”Expanded Custom”, each not Text.EndsWith([Custom.Name], “FilterDatabase”))