Forum Discussion
Update only specific table after translytical task flow
I'm trying to use translytical flows to writeback into Fabric Sql and the writeback works but after I only have the option to reload the entire data model.
I would like for just a specific table to automatically update in my semantic model that is in import mode. what would be the best way to achieve this?
Hi ThomasF,
Here's some quick steps to get the behaviour you are needing:
- Best fit for most teams: Chain a Semantic model refresh pipeline step and select only the table you changed. In Fabric Data Factory, add the “Semantic model refresh” activity and, under Settings, choose the specific tables/partitions to refresh (no need to refresh the whole model). Docs: Semantic model refresh activity
- Trigger straight from your user data function: Call the Enhanced Refresh REST API immediately after the writeback and pass an objects array that lists just your table. This avoids a full model refresh. Requires PPU/Premium. Docs: Enhanced refresh (table/partition-level)
- If you prefer XMLA/TMSL: Execute a TMSL refresh that targets only your table or partition (via XMLA endpoint, Premium/PPU). Useful if you already automate with SSMS/PowerShell. Docs: TMSL Refresh command
If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.
2 Replies
Hi ThomasF,
Here's some quick steps to get the behaviour you are needing:
- Best fit for most teams: Chain a Semantic model refresh pipeline step and select only the table you changed. In Fabric Data Factory, add the “Semantic model refresh” activity and, under Settings, choose the specific tables/partitions to refresh (no need to refresh the whole model). Docs: Semantic model refresh activity
- Trigger straight from your user data function: Call the Enhanced Refresh REST API immediately after the writeback and pass an objects array that lists just your table. This avoids a full model refresh. Requires PPU/Premium. Docs: Enhanced refresh (table/partition-level)
- If you prefer XMLA/TMSL: Execute a TMSL refresh that targets only your table or partition (via XMLA endpoint, Premium/PPU). Useful if you already automate with SSMS/PowerShell. Docs: TMSL Refresh command
If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.
Hi ThomasF ,
We would like to confirm if our community members answer resolves your query or if you need further help. If you still have any questions or need more support, please feel free to let us know. We are happy to help you.
tayloramy,Thanks for your prompt response
Thank you for your patience and look forward to hearing from you.
Best Regards,
Prashanth Are
MS Fabric community support
