History Data in Direct Query

Hii vamshikrishna20 

Create a hot/cold hybrid table with the latest three months in an Import partition and older data in a DirectQuery partition. This is an advanced setup configured through the XMLA endpoint using TMSL/TOM or tools such as Tabular Editor, and the related dimension tables should preferably use Dual storage mode.

The link below explains this:

https://learn.microsoft.com/en-us/analysis-services/tom/table-partitions?view=sql-analysis-services-2025 

It relies on Hybrid Import/DirectQuery partitions in Power BI Premium/Fabric, managed through XMLA/TMSL. All of these are documented, officially supported features, and the model automatically routes queries to the appropriate partition based on the date filter.