GA API loading partial data

[S_M]

Hi everyone, 

I have started facing a problem with the session level data being pulled in from GA - i pull in multiple metrics such as sessions / bounce rate / new users along with dimensions such as date / source / medium / country / campaign / browser & device category. 

However, as of yesterday, i notice that only partial data is being pulled in - while we are not GA premium users, our data set is not large enough for it to be sampled. Furthermore, if i pull in a sheet with only date / source / medium, the total sessions being pulled tallies with our GA, however, as soon as i add country, this messes up the metric. 

Would anyone have an idea why this would happen and how this can be resolved ? 

Thanks!

[v-qiuyu-msft · Accepted solution]

Hi @S_M,

The connector in Power BI Desktop to connect to Google Analytics rely on the Google Analytics Core Reporting API. The API may change in a way that affects the results of the queries we generate. You can see: Third-party service: Google Analytics connector for Power BI Desktop.

In your scenario, please try to use the latest Power BI desktop version. Besides, as the issue is more related to data which is exported from Google Analytics. According to this article, this should be a better place for you mainly discussing questions related to google-analytics-api. 

Best Regards,
Qiuyun Yu

[S_M]

Thanks, updating to the new version did resolve the problem for the most part. Unfortunately, there are still a few hourly refreshes that feed in partial data, but i will take it up from here 🙂