Forum Discussion

kanadaj's avatar
kanadaj
New Member
10 years ago

Can't import from Google Analytics

When I'm trying to import data from Google Analytics, I'm getting the following error:

 

Data source type
Data source error We received unexpected data for a column of type 'Date'.
Correlation ID 32bb7687-80f4-1ce4-f64a-b29e9ef8a8d3
Activity ID df6dbc14-f645-4f97-bb4f-0e68085a238f
Request ID 9ad46d79-546d-f81b-ad9d-642ad2f01b76
Time Tue Jun 28 2016 16:13:03 GMT+0100 (GMT Summer Time)
Version 13.0.1500.307
Cluster URI https://wabi-west-europe-redirect.analysis.windows.net
 
Has anyone seen/fixed this before?

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    Hi kanadaj,

    Based on the above error message, there are some issues with the source data. Have you checked that if the Date column contains incorrect values or if these Date values have general format?

    Thanks,
    Lydia Zhang

    • kanadaj's avatar
      kanadaj
      New Member
      10 years ago

      Hi Anonymous,

       

      This error happens during the initial import from gA using the service, and I don't have the slightest idea where exactly it's getting that Date column for or what is in it.

       

      Also, Power BI Desktop seems to have no problem importing data from Google Analytics, so the whole error is lost on me. If at least it told me what the invalid value was, or where it was found...