Cannot see native Query in PowerBI

[Anonymous]

Hi all,

I want to use a incremental refresh, therefore i need query folding. I have a snowflake source and added a query in the sql statement. this will give me the current statement in M [EnableFolding=true]. But when i apply steps afterwards, I cannot select 'view native query'. this is greyed out. Any tips for this?

[Idrissshatila]

Hello @Anonymous ,

you can use incremental refresh without query folding, also when it's grayed out then there's a step that broke the fold.
check this out https://youtu.be/Kui_1G6kQIQ?si=J_SergqGU-wsPDNf

[Anonymous]

hi @Idrissshatila ,

I did try it without folding. But when i do this, publish and reload in service, it is still refreshing after 2 hours. Normally it takes 30-40 minutes to reload the report.