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

[gk2go]

{"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"There weren't enough elements in the enumeration to complete the operation."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Detail","detail":{"type":1,"value":"#table({\"Content\"}, {})"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"Expression.Error"}}],"exceptionCulprit":1}}}

How do I troubleshoot this? All works well in Desktop, only in Service I get this.

[Anonymous]

I got this too, same circumstances where Desktop all loaded fine but in Service it didn't work.

The error in my case was because I replaced the source of a folder that was dependent on a helper query. Inside the helper query folder was a reference to the original source which no longer had any data.

Hope this helps someone!

[v-shex-msft]

Hi @gk2go,

Can you please share more detail information to help us clarify our scenario?

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

[Greg_Deckler]

Is that when refreshing?