GA4 Connector and Query Folding

[dazzl896]

Hi,

First off, sorry if this question doesn't make sense - it is relatively new to me.

I am trying to determine whether the GA4 connector supports query folding? I have read that incremental refresh is ineffective without query folding, but I cannot find any clear answer as to whether the GA4 connector supports query folding. The incremental refresh pop-up window says 'Unable to confirm if the M query can be folded. It is not recommended to use incremental refresh with non-foldable queries'. I also do not see the query folding icons next to my steps in Power Query. It therefore seems that query folding is not supported by the GA4 connector and that therefore incremental refresh of GA4 data in Power BI is pointless. Is this true?

Thanks in advance

[v-junyant-msft · Accepted solution]

Hi @dazzl896 ,

Regarding determining whether this data source supports query folding, you can choose this method:
Right-click, if View Native Query is selectable, then the data source supports query folding:

And for example, if my data source is excel, View Native Query is not selectable:

For incremental refreshes, the data source needs to support query folding. Otherwise the incremental refresh won't do what it's supposed to do, and instead may slow down the refresh rate. For requirements related to incremental refreshes, please refer to this document:
Incremental refresh for semantic models and real-time data in Power BI - Power BI | Microsoft Learn

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

[dazzl896]

Thank you, this is very helpful!