Google Analytics Connector in PowerBI Desktop

[Andy4581]

I've recently installed November update for PowerBI Desktop and the Google Analytics connector has stopped working.

Am getting error message "Unexpected error: Collection was modified; enumeration operation may not execute."

Any advice?

[ladyliana]

Thanks @WillHopkins!!

[v-qiuyu-msft]

Hi all, 

Please share fiddler trace as I mentioned in previous post with us, so we can try to analyze the issue. Also please provide desktop trace log around the time the issue occurs. 

@WillHopkins Thanks your for your workaround. 

Best Regards,
Qiuyun Yu 

[doyleg_OEH]

Thanks @WillHopkins. Legend.

[LeeWitten]

Cheers WillHopkins   

[Anonymous]

Thanks @WillHopkins

[Anonymous]

I had the same problem after updating to the November 2018 release. Followed @WillHopkins' steps to remove the GA credentials, then re-added them, and now the probem is solved.

[PrestaPower]

hey WillHopkins, i tried to force a re-authentification as you said, worked at first, but then when i re-opened the reports and tried to get more data from google analytics, the same error was displayed : "Unexpected error: Collection was modified; enumeration operation may not execute."

Of course doing that each and every time i want to get google analytics data does not seems a long term solution. Anyone have an idea to solve this ?

[v-qiuyu-msft]

Hi @PrestaPower, 

Please share desktop trace log and fiddler trace with me as suggested in my previous post. 

Best Regards,
Qiuyun Yu 

[jozefgabriel]

Hey,

the same issue here. Happens every few hours to every few minutes while working on the report.

Issue temporarily solved after manually deleting credentials, forcing PBI to authenticate the queries again.

[PrestaPower]

Hi @v-qiuyu-msft,

Where can i get this information ?

Best Regards