Google Analytics Connector in PowerBI Desktop

Status: New
by Andy4581 Visitor on ‎11-14-2018 08:43 AM

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?

by Kalvis Visitor
on ‎11-22-2018 01:06 AM

 @PrestaPower and @v-qiuyu-msft I have the same problem. 


Is there any other workaround for this issue?

by LeeWitten Visitor
on ‎11-22-2018 01:12 AM

The only workaround is to remove the credentials as WillHopkins menioned and re-add them, but you'll have to do this everytime you refresh your data.


Hopefully someone has sent the trace over so they can investigate and fix it.

by Tukas Visitor
on ‎11-22-2018 03:17 AM

@v-qiuyu-msft - I have done what you asked and installed and run Fiddler when reproducing the error.


I've sent you a PM with the trace report - hope it help you getting our problem solved!

by Tukas Visitor
‎11-22-2018 04:54 AM - edited ‎11-22-2018 04:56 AM

Just another thing, @v-qiuyu-msft.

Since I've had the same problem happening to me yesterday, I've configured (yesterday) the data gateway with my Power BI desktop file and set the credentials for google analytics to test scheduled refresh for 9h30m GMT-2 (Power BI Free):

   > the data was successfully updated Today after 15 minutes (Brazilian Portuguese):
Atualização PBI.PNG

   > after an hour the website where the report was published got the updated data.

   > and all of this happened with Power BI Desktop presenting this problem yet again this morning (after updating the Google Analytics credentials yesterday as @WillHopkins recommended)

   > so it seems the connection problem only happens on the desktop client.

Hope these informations help you out!

by Moderator v-qiuyu-msft
‎11-23-2018 01:38 AM - edited ‎11-23-2018 01:39 AM

Hi all, 


Please share fiddler trace and desktop trace log with us as I mentioned before, so we can try to investigate the issue further. 


@Tukas Already replied via private message. 


Best Regards,
Qiuyun Yu 

by rthomsen Visitor
on ‎11-23-2018 02:23 AM

Hi @v-qiuyu-msft


Can you please describe the steps I need to follow to create the logs you need?


This issue is challenging my workflows to the point where I may need to downgrade to the previous Power BI version unless a solution is found soon. But I haven't done any troubleshooting of this sort before, so I'd like to know how I should proceed.



by LeeWitten Visitor
on ‎11-23-2018 02:26 AM

@rthomsen, the trace has already been sent so we're all playing the waiting game now.

by Moderator v-qiuyu-msft
on ‎11-26-2018 12:20 AM

Hi all, 


The issue has been reported internally: CRI 93390259. Will keep you update once I get any information. 


Best Regards,
Qiuyun Yu 

by Moderator v-qiuyu-msft
on ‎11-27-2018 06:41 PM

Hi all, 


The fix will be available in Power BI desktop December version. 


Please try @WillHopkins's workaround (clear credential for Google Analytics) currently. 


Best Regards,
Qiuyun Yu 

by rthomsen Visitor
on ‎11-27-2018 11:13 PM


That's great news!

The workaround works fine for the time being, and I'm glad to hear this will be fixed in the near future. Thanks for the update.

Idea Statuses