Forum Discussion

Koritala's avatar
Koritala
Post Patron
8 months ago
Solved

Redshift 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 l...
Need Help
  • v-tejrama's avatar
    v-tejrama
    8 months ago

    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.

Koritala's avatar
Koritala
Post Patron
8 months ago

Hi Tejrama,

Thanks for your response.

Thing is like, when I try to import the redshift view to power bi desktop using getdata option and selected the view and clickon load option, after few seconds or a minutes it is throwing a message saying that view has a maximum row limit in size and connect in direct query mode. selected view is not loading into power bi memory if i choose Import mode.

Please sugest in this case how to takle the situation.

Thanks,

Sri

v-tejrama's avatar
v-tejrama
Community Support
8 months ago

Hi Koritala ,

 

Thank you Shubham_rai955  for the helpful input!


Were you able to resolve the issue? If the response addressed your query, kindly confirm. This helps keep the community informed and improves solution visibility.


Thank you for your support!

  • v-tejrama's avatar
    v-tejrama
    Community Support
    8 months ago

    Hi Koritala ,

     

    I wanted to follow up and see if you had a chance to review the information shared. If you have any further questions or need additional assistance, feel free to reach out.

     

    Thank you.