cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Paulien1989
Advocate II
Advocate II

Creating larger tables from Google Analytics

Hi everyone,

 

Currently I'm working with data from Google Analytics in Power BI. Anyone who's done this before, knows what a pain GA's API can be... When getting data, you have to manually construct a table that may consist of no more than 7 dimensions and 10 metrics. Which is giving me problems.

 

I need to add tables with sometimes more than 10 dimensions. I tried appending queries, but then the data from one query will all turn out as null.

 

Is there a way to work around these API limitations and create whatever tables I want with Google Analytics data?

 

Important note: I have to always include Date and Client ID in every single table (so that's two dimensions already).

3 REPLIES 3
DouglasEmil
Frequent Visitor

HI, If you don´t mind me asking how did you get Client ID? I fully agree with you on API limits. Found a link that explains a little https://developers.google.com/analytics/devguides/reporting/realtime/v3/limits-quotas.

Kr DouglasEmil

@DouglasEmil - were you able to get the ClientID from GA. Im making a basic visual in PBi connecting to GA but cant identify a unique ID to link all the data through all the dimensions in there. Can you help?

v-sihou-msft
Microsoft
Microsoft

@Paulien1989

 

Since it's Google Analytics API limitation, it can't help too much from reporting tools side to slice the source model with more that 7 dimensions. I suggest you make a feature request to Google Analytics:

 

https://developers.google.com/analytics/help/

 

Regards,

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!