Getting error while refreshing Power BI dataset

Hi PK950309 ,

Thank you Wikkleyn_81 Natarajan_M  ,for your insights.The refresh may be failing because incremental refresh is creating large queries that Redshift needs to run, and the available memory per query is limited by WLM slots and concurrency. To help, try reducing the amount of data processed during each refresh by narrowing the refresh window, making sure RangeStart/RangeEnd filters are applied early and pushed down to Redshift (check View Native Query), and removing any unnecessary columns. On the Redshift side, you may want to optimize WLM memory and concurrency settings, and use more restrictive filters. If you’re using an on-premises gateway, make sure it has enough resources and avoid running several heavy refreshes at the same time.

Configure incremental refresh and real-time data for Power BI semantic models - Power BI | Microsof…

Understanding query evaluation and query folding in Power Query - Power Query | Microsoft Learn

Monitor and optimize on-premises data gateway performance | Microsoft Learn

Query performance improvement - Amazon Redshift

Implementing manual WLM - Amazon Redshift

Thank you,