Forum Discussion

IAMCS's avatar
IAMCS
Icon for Helper I rankHelper I
10 months ago

Semantic Model refresh failure in pipeline

below is the error: Semantic model refresh execution failed, error message received from semantic model refresh operation - '{"errorCode":"ModelRefresh_ShortMessage_ProcessingError","errorDescription":"Retry attempts for failures while executing the refresh exceeded the retry limit set on the request.\n0x414700EF: {\"RootActivityId\":\"5E54B192-8E08-48C6-BA10-A8FFFE759EB4\"}\n0x413A0003: Column '<oii>Pulse Survey_motivation rate<\/oii>' in table '<oii>db_comments_test<\/oii>' cannot be found or may not be used in this expression. Table: db_comments_test.\n0x413A0003: Column '<oii>Workforce size<\/oii>' in table '<oii>db_comments_test<\/oii>' cannot be found or may not be used in this expression. Table: db_comments_test.\n0x413A0003: Column '<oii>Gender parity ratio<\/oii>' in table '<oii>db_comments_test<\/oii>' cannot be found or may not be used in this expression. Table: db_comments_test.\n0xC1450012: {\"error\":{\"code\":\"DMTS_MonikerWithUnboundDataSources\",\"pbi.error\":{\"code\":\"DMTS_MonikerWithUnboundDataSources\",\"details\":[{\"code\":\"Server\",\"detail\":{\"type\":1,\"value\":\"u73waxqq2q4e3odvspfbflodby-jry6vyg6yfrufiayxpvpuzww5u.datawarehouse.fabric.microsoft.com\"}},{\"code\":\"Database\",\"detail\":{\"type\":1,\"value\":\"vis_industrial_dshbd\"}},{\"code\":\"ConnectionType\",\"detail\":{\"type\":0,\"value\":\"Sql\"}}],\"exceptionCulprit\":1}}} Table: fact_kpi_ind_transformation_pipeline. Partition: fact_kpi_ind_transformation_pipeline.\n0xC14700F0: {\"RootActivityId\":\"5E57B192-8E08-48C6-BA10-A8FFFE759EB4\"}"}' 

below is the response from gpt: 

Yes thes column are part of a table in semantic model but the table and columns mentioned in error or as by gpt are not the part of refresh, I am trying to refresh a particular table , which doesnt contain any column as mentioned in the error. I changed nothing , earlier this pipeline was working fine 

 

 

cicd

5 Replies

  • wardy912's avatar
    wardy912
    Icon for Super User rankSuper User
    10 months ago

    Hi IAMCS 

     

     The following is AI generated and unverified, but I hope it helps:

     

    This error suggests that the semantic model refresh is failing because of invalid column references and possibly unbound data sources. Let’s break down the key points:

    What the error means

    1. Column not found

      • Columns like Pulse Survey_motivation rate, Workforce size, and Gender parity ratio in table db_comments_test cannot be found or used in the expression.
      • This usually happens when:
        • The semantic model still has measures or calculated columns referencing these fields.
        • The table or columns were removed or renamed in the underlying data source.

    2. Unbound Data Sources

      • The error DMTS_MonikerWithUnboundDataSources indicates that the refresh process cannot bind to the expected data source (vis_industrial_dshbd on Fabric SQL DW).
      • This can occur if:
        • The connection credentials expired or changed.
        • The dataset lost its binding to the source after a schema change.

    3. Retry limit exceeded

      • The refresh tried multiple times and failed, so it stopped.

    Why this happens even if you refreshed only one table

    • In Power BI/Fabric semantic models, refreshing any table triggers dependency checks across the entire model.
    • If other tables or measures reference missing columns, the refresh fails—even if the problematic table isn’t part of the refresh scope.

    ✅ How to fix

    1. Check model dependencies

      • In Power BI Desktop or Fabric workspace, open the semantic model.
      • Go to Model view → Manage relationships → Measures.
      • Search for references to db_comments_test and those columns.
      • Remove or update any broken measures/calculated columns.

    2. Validate schema

      • Confirm that db_comments_test exists in the source and has the expected columns.
      • If columns were removed, update the model accordingly.

    3. Check data source binding

      • In Fabric, verify the connection to vis_industrial_dshbd.
      • Re-enter credentials or rebind if necessary.

    4. Test with a full refresh

      • Sometimes partial refresh fails due to dependency checks. Try a full refresh after fixing broken references.

    --------------------------------

    I hope this helps, please give kudos and mark as solved if it does!

     

    Connect with me on LinkedIn.

    Subscribe to my YouTube channel for Fabric/Power Platform related content!

    • IAMCS's avatar
      IAMCS
      Icon for Helper I rankHelper I
      9 months ago

      Yes thes column are part of a table in semantic model but the table and columns mentioned in error or as by gpt are not the part of refresh, I am trying to refresh a particular table , which doesnt contain any column as mentioned in the error. I changed nothing , earlier this pipeline was working fine 

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 months ago

    Hi IAMCS 

    Thank you for reaching out to the Microsoft Fabric Forum Community.

    wardy912 Thanks for the inputs.

    The steps provided by user was helpful. as per user please check dependencies, broken measures/calculated columns.If you still have questions, please don't hesitate to reach out to the community.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 months ago

      Hi IAMCS 

      Hope everything’s going smoothly on your end. I wanted to check if the issue got sorted. if you have any other issues please reach community.