Google Analytics dimension limit workarounds

[Sunkari]

Hi All,

We are doing reporting on google analytics data. While pulling data from google analytics we have restrictions on the number of dimensions(Max allowed 7 dimensions per query).

Requirement: We need to report on more than 7 dimensions, which is not possible in Power BI right now.

One solution is getting data in two or three Power queries and combine those and creating consolidated fact table. But there joining between two queries will be a challenge(finding join columns).

Could you please provide your inputs here. 

[v-ljerr-msft]

Hi @Sunkari,

---

Requirement: We need to report on more than 7 dimensions, which is not possible in Power BI right now.

One solution is getting data in two or three Power queries and combine those and creating consolidated fact table. But there joining between two queries will be a challenge(finding join columns).

---

It seams a possible solution here to break the 7 dimensions limitation of Google Analytics Core Reporting API. But without knowing your dimensions, it's hard to help further on joining between the two queries(finding join columns).

In addition, I found an article about Google Analytics API More then 7 dimensions here. And I'm wondering if it could help in this scenario with Power BI. 

Regards

[Sunkari]

Thanks @v-ljerr-msft. It might help. I need to check whether creative filtering will work's or not.