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
Hi Koritala ,
Power BI cannot apply Incremental Refresh when your Redshift view is connected in DirectQuery mode. Incremental Refresh only works when the data is loaded in Import or Hybrid mode, and it also needs query folding so Power BI can push the RangeStart/RangeEnd filters back to Redshift. Most Redshift views don’t support folding, and DirectQuery doesn’t use the Import engine at all, so the Incremental Refresh option simply won’t appear. Because of this, a sample PBIX can’t show Incremental Refresh on DirectQuery, any working example must use Import mode with a source that supports folding, such as a materialized view or a physical table. To move forward, try loading data from a materialized view, a proper table, or a simplified view that folds correctly. After that, Incremental Refresh will work normally.
Microsoft’s own documentation and known limitations confirm all these points (see links below for reference):
https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview
https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-configure#query-folding
Hi Koritala ,
I hope the information provided above assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need.
- Koritala
Hi sshirivolu,
Still I couldn't see the native sql option.
Regards,
Sri
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.