Forum Discussion
Redshift DB views Incremental Refresh Solution In Power BI
Hi Koritala ,
In Power BI, a Hybrid table is a single table that combines both Import mode and DirectQuery for different parts of its data. Usually, historical data is imported and stored in memory, while the most recent data is kept in DirectQuery mode, allowing Power BI to access the latest records directly from the source. This setup is automatically created when incremental refresh is enabled on a Premium or Fabric capacity, together with real-time data access.
As a result, most of the table is imported, and only a small, recent section stays in DirectQuery, giving users the benefits of both Import performance and DirectQuery freshness in one table. This is referred to as a Hybrid table in Power BI.
I'm also providing the Microsoft links for your reference--https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview?utm_source.
Thank you.
Hi Tejrama,
After I read your commnets my understanding is if Redshift views definetions are having joins, incremental refresh will not work. To make it happen we need to change the views either into tables or Materialized views to enable the query folding option.
Please correct me if my understanding is correct or not?
Thanks,
Sri
Hi Koritala ,
You’re very close, but there is an important detail to clarify so you have the full picture. Incremental refresh does not work in DirectQuery mode at all, regardless of whether a Redshift view has joins or folds correctly. As long as the model is in DirectQuery, incremental refresh will remain unavailable. The reason people often move from a view to a table or a materialized view in Redshift is that those objects typically fold cleanly, which then allows the model to be switched back to Import or Hybrid mode. Once the data is coming from a foldable table and the model is no longer DirectQuery, Power BI can push the date filters back to the source and incremental refresh can finally work.
So it isn’t just the joins in the view that cause the issue. The real requirement is having a foldable source and using Import or Hybrid mode. Converting the view into a table or materialized view is the right approach, and once you do that and reload the model in Import mode, incremental refresh will behave as expected.
Thank you.