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."
@PrestaPower and @v-qiuyu-msft I have the same problem.
Is there any other workaround for this issue?
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.
@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!
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):
> 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!
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
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.
@rthomsen, the trace has already been sent so we're all playing the waiting game now.
The issue has been reported internally: CRI 93390259. Will keep you update once I get any information.
The fix will be available in Power BI desktop December version.
Please try @WillHopkins's workaround (clear credential for Google Analytics) currently.
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.