Forum Discussion
Advocate IIReversed 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.
-
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.-
Community SupportHi dmkblesser ,
Thanks for reaching out to the Microsoft Fabric community. On the basis of your question and the suggested solution by the lbendlin , We reaching out to check whether you have managed to set up the desired configuration using TMSL/XMLA commands. Do you get a hybrid table successfully configured with incremental refresh or have any issues in setting up the partitioning?
Thank you, lbendlin for sharing your valuable insights.
If you need any additional details, feel free to ask we are here to assist you.
Best regards,
Yugandhar.
Advocate IIHi V-yubandi-msft , unfortunately, it didn't work out for me. Could you please provide some examples or detailed steps to set up a sample table? Thank you!
- V-yubandi-msft
Hi dmkblesser ,
Thanks for reaching out. We found a related thread that might help you with your issue. Check out the link below. it could have the answers you're looking for.
Link: Incremental Refresh and Hybrid Tables in Power BI - Microsoft Fabric Community
If you need any more help or additional info, don't hesitate to let us know we're here and happy to assist.
If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.- dmkblesser
Hi V-yubandi-msft , the link you shared is a regular hybrid table. but I'd like to have it in a reversed order. What I mean is having import for the most recent data and DQ for the historical portion.
- V-yubandi-msft
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. -