Reversed hybrid table with incremental refresh

Hi guys, Has anyone successfully constructed a reverse hybrid table with incremental refresh? (having the cold data in DQ and hot data in import mode) I was trying to follow some tutorials bu...

Need Help

V-yubandi-msft
1 year ago
Hi dmkblesser ,

Thanks for your response. You're looking for a Reverse Hybrid Table where recent data is in Import mode and historical data is in DirectQuery.

Have you tried this approach.

Set up Incremental Refresh in Power BI to create partitions.

Use Tabular Editor or TOM API to convert older partitions to DirectQuery.

Apply dataCoverageDefinition to specify which partitions should be Import vs. DirectQuery.

Validate Queries to ensure smooth performance.

Have you tried modifying partitions after setting up incremental refresh? Let us know where you're facing challenges.

Helpful References : Use hot and cold table partitions to optimize very large Power BI data models | Microsoft Learn.

Regards,
Yugandhar.

dmkblesser

Advocate II

1 year ago

Hi lbendlin, thanks for the reply. The part you refered to, it covers the hybrid table part but not the incremental refresh part. what I'm trying to achieve is say I have data from 2020 till now.

I want 2020-01-01 - 2023-12-31 in DQ and 2024-01-01 to 7 days before today in archive (Import) and incrementally refresh the past 7 days data (import).