Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Hi @Harsh1989
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 ea...
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.