SSAS Tabular Model Error while opening model on the workspace database.

Question

Hi guys,

I was working on a model and there is a duplicate value in one of the tables which is causing an error. The error occured when I removed a filter which caused a duplicate value in one of the relationships. I was just going in to apply the filter back on to the table when SSAS crashed. Now whenever I open the model I am getting the error below. I can see the model tables when I open it in SSMS. Is there any way to apply a filter to the Table inside SSMS so that it doesn't error when opening the model in SSAS?

EDIT:
Does anyone know how to add a filter to the XML in SSMS?
I need to add 1 filter to the table and this will fix the issue. Please see the screenshot below:
![83753-fix.png][2] [2]: /api/attachments/83753-fix.png?platform=QnA

Answer 1

Hi,

Does anyone know how to add a filter to the XML in SSMS?

Find the project folder, Open the .bim file with NotePad and you can add the M code in the tabular project definition file. Then process and deploy the project, hope this could solve you problem.

Regards,
Lukas

Answer 2

I fixed this problem by changing the Integrated Workspace Mode option from False to True.

I said that my experience might be useful for you