Forum Discussion
Basic Power BI Question with Google Analytics
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.
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!
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)
