Forum Discussion
Incremental refresh with Amazon Redshift
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!
1 Reply
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
