Forum Discussion

wferrell's avatar
wferrell
New Member
9 years ago

Basic Power BI Question with Google Analytics

Hi,

 

I am tring to build a very basic table which pulls data from GA and displays daily users, sessions, page views, organic search acquisitions, and referral acquisitions.  When i pull the data together, I get the following.  Any help on how I can see this data

correctly would be greatly apprecieted.

 

Thanks,

WIL

 

Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

10 Replies

  • kaushikd's avatar
    kaushikd
    Resolver II
    9 years ago

    wferrell

    Hi Buddy i dont know much about GA and the mode of connection between PowerBI and GA, but the problem (fill down of a single attribute value for every record) as in your case Average Session Duration, Page Views, and Sessions are same for each records.

    This type of problems occurs during:-

    1. Improper modeling of measure( Average Session Duration, Page Views, and Sessions).Measure must be a numeric data type when sometimes its datatype is mistaken as text then same values gets rolldown for every record.

     

    2. Improper Relationship, sometimes when your data is coming from 2 or more than 2 tables using join, suppose a measure is picked from a Table A and some fields are picked from Table B if there is no relationship exists between Table A and Table B then same value of measure will be rolled down.

    • wferrell's avatar
      wferrell
      New Member
      9 years ago

      kaushikd  I think it is the second problem.  I want to use date as the primary key to join but I do not see where in the web interface to make this connection.  Any idea??

       

      Thanks!

      • kaushikd's avatar
        kaushikd
        Resolver II
        9 years ago

        wferrell

        While creating relationship make sure that both the datasets have keys to join(Table A and Table B both should have datekey)

        or  do one thing pick the date for the main table itself  from which you are picking other measures like(Sessions, views etc)