Forum Discussion
Incremental Refresh for Snowflake as a data source in Power BI
Hi Team, I am using snowflake views as a source in my Power BI report. I can see that view native query option in Power query is disabled for me. I tried to implement incremental refresh in my report...
The Snowflake connector does support query folding and you can do incremental refresh on Snowflake. The problem is that for some connectors, such as Snowflake, the "View Native Query" option does not work so you can't see the SQL queries Power BI generates in Power BI Desktop. That doesn't mean query folding isn't happening.
Apart from looking at the SQL queries generated in the Snowflake portal can also use Profiler and the Execute Source Query event that I blogged about here https://blog.crossjoin.co.uk/2024/09/15/another-way-to-get-the-sql-generated-by-power-bi-directquery-mode/ to see the actual SQL queries generated by Power BI Desktop.