Forum Discussion
Post PatronRedshift views incremental refresh possibility in power bi
Hi Koritala ,
The reason View Native Query is still greyed out is because your Redshift view is a bit complex, and Power BI is not able to fold the query automatically, this is very common with views. To get incremental refresh working, you can follow a simple approach that is switch your table to Import mode (or Hybrid if you have Premium), then create a materialized view in Redshift with the same logic. After that, connect to this materialized view directly from the navigator without using any custom SQL. Once you apply the RangeStart/RangeEnd filter step in Power Query, the 'View Native Query' option will become active and incremental refresh will start working properly.
Materialized views behave just like normal tables in Power BI and almost always fix this issue.
Post PatronHi Sandip,
Is this possible to share sample pbxi file?
After I read your comments, we can setup Incremental refresh only for the Import Redshift views only and can't setup Direct Quert mode views in my semantic model.
Please help in this.
Thanks,
Sri
Super UserKoritala , If you are able to see the native query, it means the query is folding. But you do see that does not mean it is not folding, you have a check query at the source, refer video from Guyinacube -https://www.youtube.com/watch?v=8hjdOCni_ZY
You can use Value.NativeQuery as discussed in the above video and blog here to ensure query folding
https://learn.microsoft.com/en-us/power-query/native-query-folding
Another way is to create a String SQL before the native query and pass that in Native.Query step. The String SQL should take care of incremental data