Forum Discussion

vamshikrishna20's avatar
vamshikrishna20
Icon for Helper III rankHelper III
3 months ago
Solved

History Data in Direct Query

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 shou...
Need Help
  • rohit1991's avatar
    rohit1991
    3 months ago

    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 

  • Kagiyama_yutaka's avatar
    Kagiyama_yutaka
    3 months ago

    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.　

v-kathullac's avatar
v-kathullac
Icon for Community Support rankCommunity Support
3 months ago

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