Visual studio error : Error occurred while opening tabular model, it occurs when opening the SSAS model on the workspace. Then Visual Studio crashes because the network connection was lost. The exact error message is something like : An error occurred while opening the model on the workspace database. For example, the local tabular model development environment lose connectivity to the repository for a few seconds.
Indeed, it’s then impossible to open the SSAS Tabular model main object. In other words, the model.bim file. Visual studio somehow locked the project.
Tabular model error occurred while opening an SSAS model with Visual Studio 2019
The system displays this error:
Tabular Model Designer error in Visual Studio: This model is already open in another location by the same user. Please close the other project before working on this one.
The full error message is the following:
This model is already open in another location by the same user, please close the other project before working on this one. An error occurred while opening the model on the workspace database. Reason: This model is already open in another location by the same user, please close the other project before working on this one.
Solution is to remove the settings file
Go to the project folder and delete the settings file, with the .settings extension.
For example if the SSAS Tabular Model still have the default name : Model.bim.
And the settings file looks like this: Model.bim_YourUserName.settings
This article shows a tip on how to fix the error while opening the model on the workspace in Visual Studio. Check the DAX Functions section to learn how to use time functions in Power BI and more.
Check the DAX patterns blog for more useful formulas.
Be the first to comment