Forum Discussion

Sunkari's avatar
Sunkari
Icon for Responsive Resident rankResponsive Resident
9 years ago

Google Analytics dimension limit workarounds

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).   Requiremen...
Need Help
Tips and Tricks
v-ljerr-msft's avatar
v-ljerr-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

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. :smileyhappy:

 

Regards

Sunkari's avatar
Sunkari
Icon for Responsive Resident rankResponsive Resident
9 years ago

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