Forum Discussion

ThomasF's avatar
ThomasF
New Member
1 year ago
Solved

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 ...
Need Help
  • tayloramy's avatar
    tayloramy
    1 year ago

    Hi ThomasF,

     

    Here's some quick steps to get the behaviour you are needing: 

    1. 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
    2. 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)
    3. 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.

tayloramy's avatar
tayloramy
Icon for Super User rankSuper User
1 year ago

Hi ThomasF,

 

Here's some quick steps to get the behaviour you are needing: 

  1. 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
  2. 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)
  3. 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.