Forum Discussion
Dataflow Gen2 - Can I filter GA4 rows at source?
Hi.
Yes, I've given up using the Google Analytics connector as its not fit for purpose. Without the ability to filter, very few queries would return meaningful data. I'm forced to use the REST connector in a pipeline instead. Thanks for taking the time to reply.
Community ChampionI think it depends if the connector supports either
A) Query folding
https://learn.microsoft.com/en-us/power-query/query-folding-basics
or
B) An option to write customized queries (I haven't checked if this option exists for the Google Analytics connector, but it seems you have already looked for a place to specify a native query without finding it, so maybe it's not possible with this connector).
Alternatively, you can see if it's possible to use
C) Web connector / REST API connector and write custom API calls to Google Analytics
Hi.
Yes, I've given up using the Google Analytics connector as its not fit for purpose. Without the ability to filter, very few queries would return meaningful data. I'm forced to use the REST connector in a pipeline instead. Thanks for taking the time to reply.