Forum Discussion

S4ndyR's avatar
S4ndyR
Frequent Visitor
2 years ago
Solved

Dataflow Gen2 - Can I filter GA4 rows at source?

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 t...
pipelines
  • S4ndyR's avatar
    S4ndyR
    2 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.