Forum Discussion

Nikhil_Sinha's avatar
Nikhil_Sinha
Regular Visitor
6 months ago
Solved

Reverse Hybrid table implementation

Scenario The Power BI report should load and store the most recent 13 months of data using Import mode, ensuring fast performance and responsiveness for commonly accessed data. The report shou...
Need Help
  • RicardoTraNa's avatar
    RicardoTraNa
    6 months ago

    Hey!  Yes... this is doable, but not with a single table switching modes automatically. In Power BI you achieve this using a composite model with Hybrid Tables (Incremental Refresh + Real-time). 

    Recommended approach:

    • Use one fact table.

    • Configure Incremental Refresh.

    • Store the last 13 months in Import.

    • Keep older data as DirectQuery (real-time partition).

    • Use a normal Date slicer that shows all dates.

    Power BI will automatically route queries:

    • Last 13 months → Import (fast)

    • Older dates → DirectQuery (on demand)

    Also important to remember: DirectQuery should mainly be used when you truly need real-time or near real-time data. If your dataset refreshes daily (or less frequently), Import mode is usually the better choice for performance, stability, and lower source-system load.

    Hope that help, 

    Best Regards,

v-karpurapud's avatar
v-karpurapud
Community Support
5 months ago

Hi Nikhil_Sinha 

Thank you for reaching out to the Microsoft Fabric community forum.

 

I would also like to thank you  kushanNa  and  RicardoTraNa  for your active participation and for sharing solutions within the community forum.

I hope the information provided helps resolve your issue. If you have any further questions or need additional assistance, please feel free to contact us. We are always here to help.

 

Best regards,
Community Support Team.