Google Analytics

[Sam_Jain]

Hello Community,

I'm trying to connect PBI to Google Analytics but am facing issues establishing the connection. So the way the GA is setup is there's 42 different items and is not in a group. However for my reporting i'd like to view it as all because they all belong to the same organization. On the navigator i don't see the load or transform data option. (Greyed out) I can drill in and select a particular element (at least 3 levels down) but i would need to aggregate all as i'm looking for page views/unique page views overall.

Can someone please specify on how i can still have all and then filter on the query editor based on views/any other metrics.

Thanks

[Sam_Jain]

Hello @RM7 ,

We ended up using a different tool to aggregate those multiple views / id's data into one table and then ingest it onto PowerBI.

Thanks.

[amitchandak]

Hi @parry2k @ can you help with this.

Thanks.