Forum Discussion

J_EFC's avatar
J_EFC
Frequent Visitor
2 years ago

GA4 - Implementation 2.0

Hello all,   I'm having an issue with the GA4 Implementation 2.0 connector pulling through data and have a couple of questions.    I've pulled through the data and if I just pull through date and...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi J_EFC ,

 I’m sorry to hear that you’re having issues with the GA4 Implementation 2.0 connector. I’ll do my best to help you out.

According to your first question, it seems that the dimension is causing the issue. This dimension is used to group traffic sources into default channels. It’s possible that the dimension is filtering out some of the users, resulting in a lower total number of active users.

You can try to use a different dimension or combination of dimensions that better suit your needs to solve this issue.

You can use the following links for help:

Power Query Google Analytics connector - Power Query | Microsoft Learn

 

According to your second question, it’s not entirely clear what you mean by “unique users”. Maybe you could ask this link for help.

Power BI Google Analytics 4 Connector - Microsoft Fabric Community

If this link doesn’t have any help. Could you describe what you want in more detail without sensitive information?

 

Best Regards,

Yifan Wang

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

  • J_EFC's avatar
    J_EFC
    Frequent Visitor
    2 years ago

    Hello,


    I used a different combination and managed to get it to work, so thanks! 

     

    The unique users I am referring to is that when you filter by dates on GA, the total users are stripped down so that each user is only logged once. 

    For example if I filtered by the last week on GA, the total users on the graph matches PBi for each individual day, but the total users for the whole week doesn't.

     

    I've been told this is because the total users for the week only counts each guest once, even if they have visited more than once over that period. Then their session count is the correct amount. 


    I was wondering if anyone had found a way to only count a user once on PBi over a 7 day period etc?

     

    Thanks