Search code examples
visual-studiossasvisual-studio-2022sql-server-data-toolsssas-tabular

how to change tabular model in Visual Studio from workspace server mode to integrated workspace mode

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.

enter image description here

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?

enter image description here

Solution

  • Just like the error message says, change the properties of the model.bim in the Solution Explorer:

    enter image description here

    enter image description here

    When you change the Integrated Workspace Mode back to True you should see a message like this:

    enter image description here

    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.