topic Re: Dataflow Gen 2 - Google Analytics 4 connector in Pipelines

Dataflow Gen 2 - Google Analytics 4 connector

henrychoiyw — Thu, 05 Dec 2024 03:19:05 GMT

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

Re: Dataflow Gen 2 - Google Analytics 4 connector

Expiscornovus — Thu, 05 Dec 2024 10:26:43 GMT

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

Re: Dataflow Gen 2 - Google Analytics 4 connector

henrychoiyw — Thu, 12 Dec 2024 01:28:50 GMT

Hi Expiscornovus,

Sorry for the late reply.

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

Re: Dataflow Gen 2 - Google Analytics 4 connector

Expiscornovus — Thu, 12 Dec 2024 11:53:44 GMT

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.