Forum Discussion

dmkblesser's avatar
dmkblesser
Icon for Advocate II rankAdvocate II
1 year ago
Solved

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's avatar
    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.

    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.

V-yubandi-msft's avatar
V-yubandi-msft
Icon for Community Support rankCommunity Support
1 year ago

Hi dmkblesser ,

 

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution we provided for your issue worked for you  or let us know if you need any further assistance?

Your feedback is important to us, Looking forward to your response. 

 

Thank You.