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
Anonymous's avatar
Anonymous
Not applicable
8 years ago

jimmymitra,


When you filter rows for a column in Power BI, the column should exist in Power BI.

In your scenario, you can get data of different dimensions into different queries in Power BI, then join the queries into a single query based on proper columns.

Regards,
Lydia

  • 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