Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Incorrect results from dimensions in Google Analytics Connector

So I wanted to see how many pages had multiple page titles assigned to them (this could be due to page titles being changed over time etc). To do this, I created 2 tables, the first contained Page an...
Need Help
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago
    Anonymous wrote:

    Hi Anonymous ,

    Please check the following thread for your problem：

    https://community.powerbi.com/t5/Power-Query/Different-results-with-same-query-using-Google-Analytics-Built/m-p/647879

     

    Best Regards

    Rena

    I don't think thats the same issue. That is talking about if dimensions are compatible, these 2 are. The rounding issue they are talking about will change the number of results, but even with rounding, its impossible to get less results when adding a second dimension so that is not the issue either.

     

    I tested a custom report in analytics and it did as expected, even if the numbers are rounded and may not be 100% accurate it should at least go up in numbers, and on that link it said that was for high traffic sites, we are NOT a high traffic site (on a good day we may crack 1000 pageviews), so shouldn't be an issue for us as the data returned is extreemely small (one of the smallest datasets I have worked on in Power BI).

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi Anonymous,

      Power BI Desktop rely on the Google Analytics Core Reporting API to get data from the Google Analytics service, though Power BI desktop attempts to update corresponding to the API changes, we can't guarantee the results when use this connector. See: Google Analytics connector for Power BI Desktop.

      According to the document, I would suggest you post a thread in Stack Overflow google-analytics-api forum to get help from Google Analytics.

      Best Regards

      Rena