Reversed hybrid table with incremental refresh

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.

1. Set up Incremental Refresh in Power BI to create partitions.

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

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

4. 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.