question

OliShingfield-3708 avatar image
0 Votes"
OliShingfield-3708 asked LukasYu-msft commented

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

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?
83647-error.png


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]: /answers/storage/attachments/83753-fix.png


sql-server-analysis-services
fix.png (32.2 KiB)
error.png (13.2 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

LukasYu-msft avatar image
0 Votes"
LukasYu-msft answered LukasYu-msft commented

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
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Have you tried to edit the .bim file, did it work for you ?

0 Votes 0 ·