Power BI and Google Analytics 4

Get your website stats into Power BI using Google Analytics 4. Thankfully the Google Analytics connector has been updated to now connect to GA4. Quick walk through including how to add extra columns afterwards.
Blog post coming!
Table of contents
00:00 Introduction
00:19 Connecting to Google Analytics
03:00 Add extra columns to query
04:29 Add slicer

[@shivakarampudi8644]

Good Explanation, Waiting for other videos on GA4 - Power bi series

[@martindeangelis3748]

I need videos of GA4 - Power BI, please

[@user-ep2ps6ug9k]

You are great! Thank you!

[@Remichedepain]

Hello, i have the same error as in your navigation panel "expression.error ..." event if i selected the same as you. But now i can't create any applied step if i don't resolve this error.. Do you have any idea of where does that error come from? Thank you by advance.

[@amitzo2]

Hi, What do you mean about "we could behave" when you are about to add the pageviews? why to write a Sum measure is better then adding it straight from the data, like you did with the date? isn't the views wil be summed for each date?

[@HatFullOfData123]

The date wasn't summarised the page views was. So behind the scenes Power BI creates what is called an implicit measure for the sum of page views. But we will have to rename it in the visual and can't format the answer. If we create a measure we can name it well and format the outcome.

[@user-nc1ki9il4q]

is there a possibility to see a difference in the data that is displayed in Google Analytics 4 and Power BI?

[@HatFullOfData123]

Not sure what you are trying to do here. Power BI should have exactly the same data.

[@user-jp2go9ep8m]

This still isn't working for my organisation. It seems to connect ok and I can drill down to the 4th level "folder" as you do but when I try to expand this I get this error: "the field 'description' of the level wasn't found". Do you know how to debug this?

[@ikhsanbasjir3535]

Hey I have the same problem... have you managed to solve the issue?

[@actioncamvideo]

Great videos! My only query is in both tutorials the old and new (this one) you say, we should behave good by creating a measure instead of adding the metric directly. However you offer no explanation of what this means. So to us that know nothing about correct behaviour in Power Bi we are left wondering why!

[@HatFullOfData123]

Good point!
Creating a measure means you get to define formatting and name the measure. I should do a video

[@AR36012]

@@HatFullOfData123 Curious to know if you did a video on this?