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

Question

I know this has been asked before however, none of the "solved" seems to fit. &nbsp;I get this error when I refresh sometimes 20 times, sometimes just once and sometimes it works right away. &nbsp;I guess my confusion is it will just eventaully work and sometimes on the 1st time. &nbsp;Any idea what would cause this? &nbsp;I'm new to this as most of this was built for me, and I'm trying to learn it, but this one has the best of me and is beyond frustrating.

seaweed81 · Answer

So forgive me, when I mentioned I was new, I'll show my ignorance. &nbsp;What are you referring to specifically when you say code? &nbsp;Is this the source that I'm linked to?

imkef · Answer

This depends on what you're doing: Please copy the code from the advanced editor here to investigate.

v-yulgu-msft · Answer

Hi&nbsp;Seaweed81,
&nbsp;
The code mentioned by&nbsp;ImkeF was the Power Query code. You can get it via clicking the Advanced Editor&nbsp;in Query editor mode.

&nbsp;
What changes did you make after loading data into Power BI desktop? And whcih step caused above error?&nbsp;Was&nbsp;there any more detailed error message?
&nbsp;
Best regards,Yuliana Gu

cdspeights · Answer

There were no changes made. &nbsp;I technically created this, but am also somewhat new as well. &nbsp;I am a bit more advanced in regards to the questions, however.&nbsp;There were no changes made (outside of some transformations for cleanup, no pivots, etc). &nbsp;We are connecting to a stats page. &nbsp;There are multiple queries for different stats/scenarios. &nbsp;The easiest way to get this to work with no fuss is to delete all relationships, refresh, then go back and connect the relationships. &nbsp;But, this is getting cumbersome as we add more and more tables/queries. &nbsp;The other thing important to mention is, it's never the same table that receives the error. &nbsp;Based on all I have read about the error, it appears to have something to do with pivoted data that creates duplicates. &nbsp;I will post the code, but on a different machine at the moment and is only in the .pbix file.

cdspeights · Answer

Here is the error message.&nbsp;&nbsp;&nbsp;This is the information from the advanced editor:&nbsp;letSource = Web.Page(Web.Contents("http://www.fangraphs.com/leaders.aspx?pos=all&amp;stats=bat&amp;lg=all&amp;qual=0&amp;type=c,21,23,34,35,40,41,43,44,45,47,50,54,73&amp;season=2017&amp;month=14&amp;season1=2017&amp;ind=0&amp;team=0,ts&amp;rost=&amp;age=0&amp;filter=&amp;players=0")),Data11 = Source{11}[Data],#"Changed Type" = Table.TransformColumnTypes(Data11,{{"Header", type text}, {"#", Int64.Type}, {"Team", type text}, {"SB", Int64.Type}, {"AVG", type number}, {"BB%", Percentage.Type}, {"K%", Percentage.Type}, {"ISO", type number}, {"BABIP", type number}, {"LD%", Percentage.Type}, {"GB%", Percentage.Type}, {"FB%", Percentage.Type}, {"HR/FB", Percentage.Type}, {"wOBA", type number}, {"wRC+", Int64.Type}, {"Hard%", Percentage.Type}}),#"Removed Other Columns" = Table.SelectColumns(#"Changed Type",{"Team", "SB", "AVG", "BB%", "K%", "ISO", "BABIP", "LD%", "GB%", "FB%", "HR/FB", "wOBA", "wRC+", "Hard%"}),#"Added Custom" = Table.AddColumn(#"Removed Other Columns", "Versus", each "RH")in#"Added Custom"

Forum Discussion

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

10 Replies

Related content

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

Expression.Error: There were too many elements in the enumeration to complete the operation.

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

Expression.Error: We cannot apply operator - to types Text and Text.

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