Google Analytics Connector Returning Errors

[Anonymous]

Since around November 5, whenever I try to pull in data using the Google Analytics connector, the Data Preview and Query Editor show a large number of errors. 

What makes this error more confusing is that I'm pulling the exact same variables that I used in a report I made in lact October, which was working perfectly at the time, and which I have since reviewed and seen that it continues to work without any problems.

I've noticed the problem arises when I add in the "Date" variable, or really any variable in the "Time" folder.

I'm using the most up to date version of Power BI.

I'm curious if anyone else has been experiencing this problem, and if you have any advice on how to correct it. 

[v-janeyg-msft]

Hello@Anonymous   

Any updates?

I find an Internal ICM ID:276130202, it is about 'Cannot connect to Google Analytics since updating to PBI Desktop October and November'.

Your question is similar but not exactly the same.

If there is any news, I will update it here.

Best Regards,
Community Support Team _ Janey

[Anonymous · Accepted solution]

The problem has since resolved itself, even though I didn't change anything (about the report, my version of Power BI, the data I was pulling, or the timeframe I was looking at).
I'm not sure why this error stopped happening, but my problem has been resolved. 

[v-janeyg-msft]

Hi, @Anonymous 

That's good, sometimes there may be some temporary issues. If you problem have been resolved, You can mark your answer as solution to close the post. If you need any other help please let me know.

Best Regards,
Community Support Team _ Janey

[v-janeyg-msft]

Hi, @Anonymous 

Did you connect to the data source in this way? I need more information to judge.

Third-party service: Google Analytics connector - Power BI | Microsoft Docs

Do you mean that there are errors in the date and time column data?

Can the data be restored to normal after being loaded to desktop?

Can you connect the same data source on other machines to see if there are errors?

Best Regards,
Community Support Team _ Janey

[Anonymous]

Yes, I did connect to the data source using that guide. 

Whenever I add in any date or time dimensions, a large portion of the data entries fall under the "Date" value of "Error". 

I'm not sure if the data can be restored to normal once it's loaded to desktop, because attempting to load the data produces the error message: "Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [Expression.Error] The field 'errors' of the record wasn't found.. '."

I do not have access to another computer that I could use to test the data source connection. 

[v-janeyg-msft]

@Anonymous  

Is this problem recent? Everything was normal before?
Have you upgraded the desktop version?

Best Regards,
Community Support Team _ Janey