Error occurred while opening tabular model

This visual studio error occurs when opening the 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 .

How to fix the tabular model error message and open the SSAS model in Visual Studio?

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

Leave a Reply

Your email address will not be published.


*