Incremental refresh with Amazon Redshift

[Anonymous]

Hello, while trying to Applying incremental refresh on power bi report, i am getting warning "Unable to confirm if M query can be folded". The data source is Amazon Redshift,  I'm using the Amazon Redshift connector, and I'm using import mode.

I tried with simple table with minimum transformation ( data type change ) but got same warning. 

if anyone applied incremental refresh with redshift data ware house. please let me know. 

 Thanks in advance for your help!

[GilbertQ]

Hi @Anonymous 

What I did was to use the ODBC connection and this then enabled me to configure the incremental refresh.

Below are the details on how I got it done: Using Azure Analysis Services to connect via an ODBC Source (Redshift) - Reporting/Analytics Made easy with FourMoo and Power BI