Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Add a table in a semantic model Failed

Hello,   I add some columns in my table and when a want to update the table in the semantic model i have this error : {"error":{"code":"LoadModelFailed","pbi.error":{"code":"LoadModelFailed","pa...
General Comment
Need Help
jbauer22's avatar
jbauer22
Advocate II
2 years ago

I got the same error today when we rebuilt a table.  We are using direct lake mode.  I unchecked the box for the table that was changed in the Edit Tables and clicked confirm.  I then went back to Edit Tables added the dimension table back by checking the box and clicking confirm and it came back.  I suspect the error was related to the fact that we rename our dimensions in the semantic model and when a table is rebuilt in the lakehouse it looses the connection.  I hope this helps resolve your issue.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hello jbauer22 

    Thank you for your help.
    The fact is that when a try to add another table i have also this error.
    For make a test i try to uncheck a table and same error. Even if i try to uncheck a table or several tables or all of the tables i have this error. I made a ticket to the microsoft support.

    I do not know why and how can i fixed this

  • FilipAi's avatar
    FilipAi
    Helper I
    1 year ago

    This worked for me. I made updates to the underlying delta table, and could not refresh the model - until I unchecked that table in Edit tables for the semantic model. I could then re-add the table and  refresh the model. I did not check if it was sufficient to remove the relationship on that table.