I need help resolving a problem in SSAS. I developed a tabular model in Visual Studio (Professional 2022, with the Microsoft Analysis Services Projects extension installed). My model is small. So, I chose the 'Integrated workspace' mode option. I developed the model, saved it, and closed it. But, when I re-open the model (in Visual Studio), I encounter the error message in the screenshot below, which prevents me from further developing the model.
I experienced this error message with previous models. In all of those situations, I resolved the error by changing the Integrated Workspace Mode to False and then back to True (on the Model.bim properties window in Solution Explorer). However, in this new model, when I attempt to change the Integrated Workspace Mode property back to True, I experience the error message in the screenshot below, and I'm unable to proceed. I don't know why my workaround isn't resolving the issue for this model.
To be sure, I don't see anything in the JSON of the Model.bim file that corresponds to the workspace mode setting.
How can I resolve this?
I need help resolving a problem in SSAS. I developed a tabular model in Visual Studio (Professional 2022, with the Microsoft Analysis Services Projects extension installed). My model is small. So, I chose the 'Integrated workspace' mode option. I developed the model, saved it, and closed it. But, when I re-open the model (in Visual Studio), I encounter the error message in the screenshot below, which prevents me from further developing the model.
I experienced this error message with previous models. In all of those situations, I resolved the error by changing the Integrated Workspace Mode to False and then back to True (on the Model.bim properties window in Solution Explorer). However, in this new model, when I attempt to change the Integrated Workspace Mode property back to True, I experience the error message in the screenshot below, and I'm unable to proceed. I don't know why my workaround isn't resolving the issue for this model.
To be sure, I don't see anything in the JSON of the Model.bim file that corresponds to the workspace mode setting.
How can I resolve this?
Share Improve this question edited Jan 31 at 22:35 skyline01 asked Jan 31 at 15:26 skyline01skyline01 2,10110 gold badges40 silver badges66 bronze badges1 Answer
Reset to default 0Just like the error message says, change the properties of the model.bim in the Solution Explorer:
When you change the Integrated Workspace Mode back to True you should see a message like this:
So perhaps a setup issue. You can probably workaround by installing SSAS 2022 developer edition and using that as your workspace server.
That property is in the .smproj file, not the .bim file, so you could also try to change it directly there. Or create a new project and copy in the .bim file.