cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

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

 

Capture.PNG

10 REPLIES 10
Highlighted
Resolver II
Resolver II

Re: Basic Power BI Question with Google Analytics

@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.

Highlighted
New Member

Re: Basic Power BI Question with Google Analytics

@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!

Highlighted
Resolver II
Resolver II

Re: Basic Power BI Question with Google Analytics

@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)

Highlighted
New Member

Re: Basic Power BI Question with Google Analytics

@kaushikd

 

I do have date in both of the tables but I do not see where i can create a relationship.  Am i missing somehting on the interface?

 

Capture.PNG

Highlighted
Resolver II
Resolver II

Re: Basic Power BI Question with Google Analytics

@wferrell

Perfect In your case as I see your two tables (Daily Users and Site Overview) both have date field in it so basicly these are Fact Tables now you have to create a Dimension table for date( DimDate) and then join the DimDate-->Date field with Daily Users-->Date and Site Overview-->Date.

 

Please Follow the steps:-

1.Go to Data Tab and in modelling tab select new table

Capture.PNG

Put the code as shown in the fig to create the DimDate 

DimDate = CALENDAR (DATE (2010, 1, 1), DATE (2017, 12, 31))

 

2. Go to the Relationship mode and join DimDate table with both tables(Daily Users and Site Overviews)

 

It will look somehow like

 Capture.PNG

 

Now in the table select Date field from DimDate table,Users from Daily User table and AvgSession from Site Overview table.

 

Hope this will short out your problem.

 

 

Highlighted
New Member

Re: Basic Power BI Question with Google Analytics

@kaushikd

 

Is this available in the online Power BI as well?  i cannot find it!!

 

Highlighted
Resolver II
Resolver II

Re: Basic Power BI Question with Google Analytics

Can you share your solution..?

somehow

Highlighted
New Member

Re: Basic Power BI Question with Google Analytics

Sorry i don't understand.  I don't have a solution.  I am using the online cloud version of Power BI

Highlighted
Resolver II
Resolver II

Re: Basic Power BI Question with Google Analytics

@wferrell

 

Could you please download the file and share it somewhere so that i can access it and do the modelling for you, or else make a solution and dummy data and share that file with me.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors