Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
dazzl896
Regular Visitor

GA4 Connector and Query Folding

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

1 ACCEPTED SOLUTION
v-junyant-msft
Community Support
Community Support

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:

vjunyantmsft_0-1713320928804.png

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

vjunyantmsft_1-1713321091197.png


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.

View solution in original post

2 REPLIES 2
v-junyant-msft
Community Support
Community Support

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:

vjunyantmsft_0-1713320928804.png

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

vjunyantmsft_1-1713321091197.png


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.

Thank you, this is very helpful!

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

Top Solution Authors
Top Kudoed Authors