Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Semantic Model with On - Prem Connection & Partitioning

Hello everyone!   Currently, I have a model on Analysis Services that I modify using Tabular Editor. My goal now is to replicate this model on Fabric and create a Semantic Model, while keeping the ...
Need Help
Tips and Tricks
  • rohit1991's avatar
    rohit1991
    1 year ago

    Hi Anonymous ,

    Semantic Model with On-Prem Connection & Partitioning in Fabric

    Do You Need Partitioning?

     Yes – If handling large data and need faster refresh.
     No – If data is small and refresh speed isn't an issue.

    How to Manage Partitions?

    • Define partitions in Tabular Editor.
    • Use incremental refresh policies in Fabric.

    How to Refresh a Specific Partition?

    • Use XMLA Endpoints (if supported).
    • Automate with Power Automate or REST API.

    Best Approach

    • Use DirectQuery for real-time data.
    • Try Hybrid Tables (Import + DirectQuery) for balance.
v-pnaroju-msft's avatar
v-pnaroju-msft
Community Support
1 year ago

Thank you lbendlin and rohit1991 for your response.

Hi Anonymous ,

We would like to inquire if the solution offered by lbendlin and rohit1991 has resolved your issue. If you have discovered an alternative approach, we encourage you to share it with the community to assist others facing similar challenges.

Should you find the response helpful, please mark it as the accepted solution and add kudos. This recognition benefits other members seeking solutions to related queries.

 

Thank you.