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

Get certified as a Fabric Data Engineer: Check your eligibility for a 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700. Get started

Reply
henrychoiyw
Regular Visitor

Dataflow Gen 2 - Google Analytics 4 connector

Hi, I am trying to use the default Google Analytics 4 connector load the data to Fabric for analysis purpose with Dynamics CRM. I can successfully connected to GA4 but the tables cannot return any values for example session, sessionSource and sessionMedium. I want to ask is this due to API limitation from Google side? Is there any other way or workaround to get it work?

Thank you very much in advance.

Henry

1 ACCEPTED SOLUTION

Hi @henrychoiyw,

 

Thanks for your reply. Can you run the same request in GA4 query explorer? Does it return data in there for you GA propery?

https://ga-dev-tools.google/ga4/query-explorer/

 

If it returns data you might have found an issue related to the GA4 connector. In that case you can register a new issue (or upvote an existing one) in the Issue section of these forums:

https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues

 

Alternatively, you might also be able to use the Web API source as well as a workaround. Via the same query explorer you could figure out what the Body payload of such an HTTP request needs to be.

 

ga4queryexplorer.png

 

sessions_ga4.png



Happy to help out 🙂

I share #PowerAutomate and #SharePointOnline content on my Blog, Bluesky profile or Youtube Channel

View solution in original post

3 REPLIES 3
Expiscornovus
Super User
Super User

Hi @henrychoiyw,

 

Just to double check, which implementation version are you using for your connection? I assume the 2.0 (which is the default one).

https://learn.microsoft.com/en-us/power-query/connectors/google-analytics#prerequisites

 

 

 

 



Happy to help out 🙂

I share #PowerAutomate and #SharePointOnline content on my Blog, Bluesky profile or Youtube Channel

Hi @Expiscornovus,

 

Sorry for the late reply. 

I am using 2.0. That's the only option I have in Fabric.

Hi @henrychoiyw,

 

Thanks for your reply. Can you run the same request in GA4 query explorer? Does it return data in there for you GA propery?

https://ga-dev-tools.google/ga4/query-explorer/

 

If it returns data you might have found an issue related to the GA4 connector. In that case you can register a new issue (or upvote an existing one) in the Issue section of these forums:

https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues

 

Alternatively, you might also be able to use the Web API source as well as a workaround. Via the same query explorer you could figure out what the Body payload of such an HTTP request needs to be.

 

ga4queryexplorer.png

 

sessions_ga4.png



Happy to help out 🙂

I share #PowerAutomate and #SharePointOnline content on my Blog, Bluesky profile or Youtube Channel

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

JanFabricDE_carousel

Fabric Monthly Update - January 2025

Explore the power of Python Notebooks in Fabric!

JanFabricDW_carousel

Fabric Monthly Update - January 2025

Unlock the latest Fabric Data Warehouse upgrades!