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,

RicardoTraNa's avatar
RicardoTraNa
Responsive Resident
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,