Forum Discussion
Cannot see native Query in PowerBI
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?
2 Replies
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-wsPDNfhi 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.
