I hacked the Google Analytics connector to get GA4 data in Power BI !!!

Join this channel membership to get access to all the recorded bites as they become available:
/ @curbalen
Here you can download all the pbix files: curbal.com/don...
SUBSCRIBE to learn more about Power and Excel BI!
/ @curbalen
Our PLAYLISTS:
- Join our DAX Fridays! Series: goo.gl/FtUWUX
- Power BI dashboards for beginners: goo.gl/9YzyDP
- Power BI Tips & Tricks: goo.gl/H6kUbP
- Power Bi and Google Analytics: goo.gl/ZNsY8l
☼☼☼☼☼☼☼☼☼☼
POWER BI COURSES:
Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:
curbal.com/cou...
☼☼☼☼☼☼☼☼☼☼
ABOUT CURBAL:
Website: www.curbal.com
Contact us: www.curbal.com/...
QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Linkedin ► goo.gl/3VW6Ky
Mastodon ► @[e-mail]
Twitter ► @curbalen
Facebook ► goo.gl/bME2sB
#CURBAL #SUBSCRIBE

[@vincenzonosso7400]

I just tried to refresh within my Power BI Desktop, and it didn't prompt any error...

[@CurbalEN]

They updated the connector last month 🥳🥳

[@vincenzonosso7400]

@@CurbalEN nice, thanks 😃 Anyway, very interesting video(s) :)

[@stevenannegarn4417]

Wow. This is so incredibly stupid, the way Microsoft is handling this GA4 thing. That we need a community member to hack into it haha. Why didn't they just announced "ok it's coming last month". Thanks for finding out Ruth. You just killed two of my projects, but I'm happy :) I was working on the path trough Big Query but that's a lot harder

[@CurbalEN]

Yeah, i was looking into that too, but it is a cumbersome workaround !!

[@psanders4754]

I was doing the same lol

[@nativecascadian4141]

YOU SAVED us at my office! THANK YOU FOR THIS.

[@CurbalEN]

🥳🥳🥳

[@carltonseymour869]

Absolutely awesome Ruth. Every step was so clearly articulated. Was easy peasy to setup with this tutorial. As always thank you for sharing this with the community

[@alejandraangel7468]

Hello. I have a problem. "The field 'description' of the record wasn't found". What could be the problem?

[@wenvalderrama8854]

I have the same problem

[@carlycontri1778]

I was so excited to try this hack. While I got as far as setting up the dataflow in the web interface and refreshing, the data never refreshes, times out, and in addition when I go to the queries, I'm getting either the same error a user below mentioned with field dimensions not found or the error: error = [code = 429, message = "Exhausted property tokens for a project per hour. These quota tokens will return in under an hour. When I tried to refresh the data in desktop, I got the error that it ran out of memory. These GA4 datasets are huge - how do you account for memory and errors in loading data? Did your data actually refresh? The video ends with you refreshing the dataflow but we don't see what happens next. It would be great to see what you do with this GA4 data once it refreshes and how you build it into existing reports and/or create visuals with them. Thanks!

[@CurbalEN]

Probably you are exceeding the API quota. You need to di smaller requests or use a custom connector or 3rd party solution :(

[@cornerstone4you]

You are a super-star and I'll share the link to others in multiple communities ❤❤🎉🎉😊

[@CurbalEN]

Thanks!! 🚀🚀

[@TamásMegyeri-y4p]

Hello, I have two GA4 Properties and in one of them I get this error "The field 'description' of the record wasn't found". What could be the problem?

[@CurbalEN]

No idea, try removing the field from the query

[@TamásMegyeri-y4p]

@@CurbalEN maybe any ideas how to remove the problematic field?

[@claudianrocha]

@@TamásMegyeri-y4p the same is happening here. Did you solve it?

[@alejandraangel7468]

Did you solve it? I have the same problem

[@CurbalEN]

@alejandraangel7468 I run into that issue myself now. Remove all the filters from the dataflow and filter in power bi instead

[@jhofastcopas]

Is it possible to connect in real time? I am experiencing a delay in refreshing the information.

[@atifmir7409]

Many thanks, I was looking for exactly this!

[@CurbalEN]

🥳

[@parulgupta2662]

You rock! This is awesome.... Thanks 😊

[@CurbalEN]

🥳🥳

[@zandilions]

I don't have the social media option, how can I go about getting it? I also want to find out, how do I determine which data to select with Google Analytics? There's a whole bunch of stuff and it feels overwhelming

[@mamacassi]

Now can you show us how to combine multiple ga4 accounts into one table with the custom invoke function that you shared a few years back - that has been INVALUABLE to me!

[@CurbalEN]

Same applies , doesnt it?

[@mamacassi]

Hi there was a few changes i needed to make to the custom function but i did get it working! Thank you. Unfortunately powerbi only retrieves 50 GA4 accounts and i have 400! @@CurbalEN

[@sanjaysureshs2193]

Seems to be the same procedure is not effective with GA4, is there a way around to do this.? @@CurbalEN

[@KNP-BI]

Brilliant, thank you.

[@ajeyarjun8718]

Hi, I have basic knowledge on power bi but I want to go completely with dax what is the best way can you suggest me thanks

[@rahupradhan1889]

Hi mam, Could you please make a video on ' how to show' last 4 weeks trends and last 4 quarter trend graph. I already did it, but when we are in week 1, i am unable see week 52, 51,50,49 data. Could you please 🙏 make a video

[@SergioSepulveda-vb5pq]

Hello, please can you share de content of the steps "Navigation" and "Added Items" (sec 1:30). In my case I have the error: The Field of the record wasn't found. And I want to try writing the whole connection

[@GetResponsive]

Thank you so much - i still have to dive into GA4 at all - everything is events now and such... pfff

[@CurbalEN]

You will get into it in no time!

[@user-uu5dm7np2g]

Hi. Thanks. How download connector Power bi to ga4?

[@HughGage]

Hi, not a Power BI user but trying to figure out how to get GA4 data into Power BI. In this video it looks like you started your workflow in a desktop app and finished in the web version. I use a Mac and from what I can see MS don't offer a desktop version for Mac users. Am I missing something obvious - is there a way to complete your hack via the web version of Power BI only?

[@CurbalEN]

Oh, I see… I believe the difference in the code is the Implementation 2.0 in the code. If you add that to the code in the web version it might work. Need to check to be certain though…

[@victordias5684]

Hey, this is really good. But I've got a problem. When I tried to acess the dataflow, it didn't shown up to me. Dataflow is it available only for Pro Users?

[@CurbalEN]

Yeah, i think so :(

[@byrongallegosmarcillo7158]

I tried and it works, thanks for that. I'm not used to work in pbi service. How could I start an inform from here when my dataflow is already published?, Is it possible to get that data on pbi desktop?

[@CurbalEN]

Watch the entire video!

[@psanders4754]

what version of power bi are you using?

[@kenvjensen]

This hack does not solve the "DataFormat.Error: We found an unexpected character in the JSON input \31" error. I believe this error occurs when you try to extract too much data and exceed whatever daily limit GA enforces. Which is strange because it is extremely hard not to exceed this daily limit and if you use other ETL tools, e.g. ADF, to extract data from the GA4 API the experience indeed very good, no limits in my experience and fast. Anyone knows a hack to work around the limitations of the Google Analytics connector? Or Alternatively, how to add a WHERE clause to the query?

[@CurbalEN]

I think they have released the connector, so this hack is not needed anymore. For serious analysis of GA data you need to use other solutions. The connector is very limited.

[@jacobli2676]

I coded in Python and pull data via their API, write it to a local csv and upload it to the sharepoint folder, and then schedule it to run every day... It is not smart enough, but I've been using it for more than a year and the pipeline is pretty steady, until I realize I need to migrate to GA4....

[@CurbalEN]

Maybe the GA team has release the python code for GA4? 🤞🤞

[@jacobli2676]

@@CurbalEN Yeah, everything is there. I also tried it, it works. But the thing is that it is nearly impossible to migrate my historical data to my present dashboard. But my manager said he's okay with it. To us, UA is good enough with all the features we need.

[@CurbalEN]

But UA will stop collecting data this month. You need to migrate I am afraid!

[@EstafilococoTV]

Im getting "Access is denied" when trying to connect to my GA account using PBI desktop. Not even getting the credentials window. Help please!

[@CurbalEN]

Do you have the latest desktop version?

[@EstafilococoTV]

@@CurbalEN I was so amped up I missed that detail. Thank you!!!!

[@CurbalEN]

@EstafilococoTV Glad it worked 🥳🥳

[@NeBixAt]

Ruth, you forgot to blur data at 2:52 😅

[@CurbalEN]

It is my own data so I didnt bother :)

[@d.kishore7677]

I really Thanjavur tamil nadu India gaa sister

[@nishantkumar9570]

Awesome 🎉

[@CurbalEN]

🥳🥳

[@user-tu9ns5lw9g]

How do I merge multiple properties together?

[@CurbalEN]

I have a video on that, just search the channel :)

[@user-tu9ns5lw9g]

@@CurbalEN Yes that one helped me a lot when using UA, but does that one apply to GA4 as well?

[@joangarcia6327]

I like your dark side... 🏴‍☠ 🤣

[@CurbalEN]

😂😂

[@diegoferreira1379]

You are so braba!!