Dataflow Gen 2 - Google Analytics 4 connector

[henrychoiyw]

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

[Expiscornovus]

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

[henrychoiyw]

Hi @Expiscornovus,

Sorry for the late reply. 

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

[Expiscornovus · 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.