Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Google Analytics Connector Returning Errors

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. 

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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. 

6 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      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's avatar
        v-janeyg-msft
        Community Support
        4 years ago

        Anonymous  

         

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

         

        Best Regards,
        Community Support Team _ Janey

  • v-janeyg-msft's avatar
    v-janeyg-msft
    Community Support
    4 years ago

    HelloAnonymous   

     

    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's avatar
      Anonymous
      Not applicable
      4 years ago

      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's avatar
        v-janeyg-msft
        Community Support
        4 years ago

        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