Dataflow Gen2 - Can I filter GA4 rows at source?

[S4ndyR]

Hello.

I'm new to Fabric, and am using the Dataflow Gen 2 connector to extract data from Google Analytics 4. I can easily connect and choose the various metrics and dimensions for my query, but there is no obvious way to filter the results. I would like to filter the GA4 data at source in the actual call to extract the records, not after it has been returned - as its high volume! I an an experienced SSIS user and its very straightforward to filter records by date (e.g. I can filter for "Yesterday" via the Google API in SSIS). Is there a way to do this? Many thanks for any help.

[frithjof_v]

I 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 

[S4ndyR · Accepted solution]

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.

[S4ndyR]

Hello. Thank you very much for looking at this. Unfortunately, this only filters the incoming GA data after it has already been extracted. I need to filter the data at the point of extraction from GA4, so this will not work for me.

[Anonymous]

Hi @S4ndyR ,

I connected to the data source you described and exported the table with Date.

In Power Query you can select the column you need, right click on it to filter, and then you can select what you need to filter.

You can also get the filtered results at the end.

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.