Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
saich
Employee
Employee

I am trying to access google analytics through powerbi , but when i try to get default channel group

I am trying to access google analytics through powerbi , but when i try to get default channel groups it throws up an error. If i try to get other fields like date, city etc it is being pulled.

step by step: I am trying to load data in power bi desktop by connecting to GA4( Google ANalytics). I am getting the other fields to load and pul data except channel groups ( default channel groups). @PowerBI

3 REPLIES 3
ReportGuru
Helper V
Helper V

Hi @saich Seems like the 2.0 beta connector is still presenting some issues. As a workaround, maybe you can try to test your connection with a 3rd party tool. I use it and I've never had any problem when pulling default channel group field. I've tried windsor.ai, supemetrics and funnel.io. I stayed with Windsor because it is much cheaper so just to let you know other options. In case you wonder, to make the connection first search for the GA4 connector in the data sources list:

 

GA4-1.png

 

After that, just grant access to your GA4 account using your credentials, then on preview and destination page you will see a preview of your GA4 fields:

 

GA4-2.png

 

There just select the fields you need. Finally, just select PBI as your data destination and finally just copy and paste the url on PBI --> Get Data --> Web --> Paste the url. 

 

SELECT_DESTINATION_NEW.png

saich
Employee
Employee

saich_0-1713282097638.png

This is the error obtained when customer is trying to pull defalut channel groups fields. 

Has No errors pulling other fields as shown in pic below

saich_1-1713282502223.png

 

 

This screenshot below is from my power bi when i pull default channel groups which doesnt have any tables. I created a test GA account to check if i can get Default channel groups.

v-yangliu-msft
Community Support
Community Support

Hi  @saich ,

 

If it's convenient, could you provide the error messages you get and share them for further troubleshooting so we can better help you

Check credentials and permissions to access GA4 data.

Ensure that the relationships between tables in the data model are set up correctly, incorrect or missing relationships can cause issues.

You can also choose to create custom channel groups, which allows you to define your own rule-based categories for Web traffic sources.

[GA4] Custom channel groups - Analytics Help (google.com)

 

This is the related document, you can view this content:

[GA4] Default channel group - Analytics Help (google.com)

Default member in multidimensional models in Power BI - Power BI | Microsoft Learn

Create and manage relationships in Power BI Desktop - Power BI | Microsoft Learn

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.