Forum Discussion

carlydugger's avatar
carlydugger
Frequent Visitor
9 years ago
Solved

google analytics

Hello!    First off, thanks for reading and sharing your expertise. I'm a new Power BI user and running into some trouble with Google Analytics.   I connected GA to the desktop version of Power B...
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    Hi carlydugger,

     

    The connector in Power BI Desktop rely on the Google Analytics Core Reporting API. Although we attempt to release updates in accordance with any changes, the API may change in a way that affects the results of the queries we generate. Due to this dependency we cannot guarantee the results of your queries when using this connector.

     

    In your scenario, please try to update the Power BI Desktop to the latest version 2.39.4526.362 and connect to Google Analytics. If issue persists, according to this article, this should be a better place for you mainly discussing questions related to google-analytics-api. 

     

    In addition, we are not able to place a date hierarchy in Visual /Page /Report level filter currently. To work around the issue, you can use the custom visual HierarchySlicer.

     

     

    Best Regards,
    Qiuyun Yu

Jmenas's avatar
Jmenas
Advocate III
8 years ago

Hi offrench,

I imagine is because you have to add the samplingLevel on the cube request, not outside. As you can see in the documentation that you posted. 

POST https://analyticsreporting.googleapis.com/v4/reports:batchGet
{
  "reportRequests":
  [
    {
      "viewId": "XXXX",
      "dimensions": [{"name": "ga:medium"}],
      "metrics": [{"expression": "ga:sessions"}],
      "samplingLevel":  "LARGE"
    }
  ]
}


Still, somehow the cube request still not work because it doesn't have the same request, maybe you will have to do some work around. 

Best,

Jorge

andrescaso's avatar
andrescaso
Resolver I
6 years ago

carlydugger, I have the same problem with the data of GA, It´s something related with the API of GA and the quantity of data.
The workaround for that is, filter by dates periods in Power Query until your data match in PBI and GA.

And we will wait to Power BI team fix this problem