Forum Discussion

jimmymitra's avatar
jimmymitra
Icon for Advocate I rankAdvocate I
8 years ago

Google Analytics fetch data based on WHERE condition on a field not part of select list

Hi Experts,     I am trying to get data in power BI from Google Analytics(GA). I have encountered a situation where GA only allows 7 dimension to be added in a GA view while taking data in power B...
Need Help
jimmymitra's avatar
jimmymitra
Icon for Advocate I rankAdvocate I
8 years ago

Thanks for your reply. 

 

Just one clarification - when you say "join the queries" , what should be the joining criteria ? For example in two views we have Date, Page Path level 1, City and Country as common columns. 

Do you suggesting us to join based on these common columns or is there a particular priamry key that could be found/used to join the to views ? 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

jimmymitra,

You can choose proper fields in the two queries to make relationships(active or inactive).

Regards,
Lydia