Combine data from multiple Google Analytics accounts in one query with Power BI

You asked me in the comment box a while ago if it was possible to combine data from multiple Google Analytics accounts in just one query and in today's video, we are going to do just that.

The download file is #43, go and grab it in the download center!

SUBSCRIBE to learn more about Power and Excel BI!

Our PLAYLISTS:

☼☼☼☼☼☼☼☼☼☼

POWER BI COURSES:

Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:

☼☼☼☼☼☼☼☼☼☼

ABOUT CURBAL:

************

************

QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Twitter ► @curbalen, @ruthpozuelo

[srs]

I know this is an oldie but boy what a

[cobyyuu]

Hello, this was fantastic and I was able to create for GA4. However, I get an error at the very end when I pull in the metric data stating that the "key didn't match ay rows in the table".

[publicjewelrybox]

This is a life saver, thank you so much!

[jeffober]

This was really helpful, thank you for sharing this knowledge.

[curtas]

thank you SO much for sharing the information and for your work!

[tamermarzouk]

Very useful. thanks for sharing such knowledge

[gaurangtrivedi]

It's really helpful.. We have implemented the same as per your tutorial and it shows sources, page, date and pageviews. Now how do I add more parameters in this report such as Users, Bounce Rate, Avg. Time on Page from GA?

[persianuk]

Thank you for sharing, dose it work on GA4?

[violetamicu]

hello. Is this applied also when you have 2 GA accounts with 2 different usernames? Thanks!

[bhavithar]

Hi Very Useful, Thanks for Sharing the information
Is There Possible way to switch between Google Analytics website data in power Bi
Example : i have staging environment AllWebsiteData (Stage-A) and UAT environment AllWebsiteData (UAT-A) (in a same Account)
already custom report has been prepared using Stage-A
now is it possible to switch to AllWebsiteData(UAT-A) which will result in UAT-A data in the existing custom report

[nacho.hurtado]

Hi there!!
Wich is the best way to get the bounce rate from analytics? Because if im campare the average in power bi with the result in analytics its not the same. Maybe creating a new metric?
Also, I combine 8 different google analytics sources
Thanks in advance

[qianlinding]

I have a question. If I want to make the ga:data as a date parameter in this function. So I can custom the date for GA metrics. How should I do it? Is it Parameter Name, {"ga:date"}, {"Date"}) ???

[kantharajuds]

Ver Informative Thanks!
Is there a possible way to query morethan 7 dimensions from Google Analytics to Power BI?

[parulgoyal]

How can I import multiple websites data linked to my GA account at once

[Jesseso]

It seems that I cannot access the pbix file. Where can I download this? Thanks