Forum Discussion
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
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.
3 Replies
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
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.
