History Data in Direct Query

[vamshikrishna20]

Hi All, 

I wanted to check with you all for one of my clients ask:

The Ask is - for a report we should import last 3 months of data and when user filters anything beyond 3 months , report should fetch beyond 3 months data in direct query. 

By any chance , is it feasible

TIA

[rohit1991 · Accepted solution]

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

[v-kathullac]

Thankyou @Kagiyama_yutaka , @rohit1991   for Addressing the issue.

Hi @vamshikrishna20  ,

Thank you for reaching out to Microsoft Fabric Community Forum,

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

Regards,

Chaithanya

[v-kathullac]

Thankyou @Kagiyama_yutaka , @rohit1991   for Addressing the issue.

Hi @vamshikrishna20  ,

Thank you for reaching out to Microsoft Fabric Community Forum,

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

Regards,

Chaithanya

[Kagiyama_yutaka · Accepted solution]

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.　

[rohit1991 · Accepted solution]

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