Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
Anonymous
Not applicable

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 and Pageviews, the second had Page, Page Title and Pageviews. Page and Page Title are dimensions and Pageviews is a metric.

 

I figured that however many extra results were in the second table compared to the first would tell me how many pages had multiple titles assigned to them. However, when I did this, I got 1795 rows in the first table, and 1124 in the second! It should be impossible to have less results by adding a second dimension, as you are adding an extra field that the data needs to be broken down by, so how has this happened?

 

Is this a known bug in the connector? I'm not sure I can trus the data if there is a fundamental issue like this in it.

3 REPLIES 3
v-yiruan-msft
Community Support
Community Support

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

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable


@v-yiruan-msft 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).

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

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.