Forum Discussion
Post PatronRedshift DB views Incremental Refresh Solution In Power BI
Hi All,
I have redshift database views as source for my semantic model.
many views are having huge volume of data (morethan 1000000 rows). when I tried to import views it is exceeding the maximum limit and saying Import mode doesn't support.
Then I use the Direct Query mode. After that when I try to implement the Incremental refresh approach my creating parameters, view native SQL is not enabling in applied steps.
Can anyone help in this, how to setup incremental approach with Redshift data base views. Whether Power BI support this feature with Resdshift db or not.
I need to refresh data on incremental approach only on daily basis.
Thanks,
Sri.
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.
