Forum Discussion
Web Pull Error - query. Expression.Error: There weren't enough elements in the enumeration to comple
Hi All, I have a web data power query that I use to pull a table from multiple URLs. When I build out this table from scratch it populates perfectly fine. However, every time I go to refresh the...
When fixing Power Query formula errors, you have to look at Table.SelectRows or List.Count in the editor to see if these parameters are out of bounds, and it is recommended to add conditional judgments like if List.Count(source) > 0 then.... . else null, to ensure that the enumeration element exists before processing!