- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-05-2026
10:54 PM
Hi @F003Yum ,
Your Snowflake history shows incremental refresh is working, and the SHOW COLUMNS and SHOW PRIMARY KEYS queries are expected metadata calls. The main cause of slow or inconsistent refresh is the Table.Group step, which can break query folding and force processing to the Power BI engine. When folding is lost, each partition executes locally, increasing refresh time even with incremental refresh. To improve performance, move aggregations to Snowflake via a view or native query and verify folding using View Native Query. Keeping transformations foldable lets the source handle execution efficiently.
272 Views