Error occurred while opening the model on the workspace

If facing an Error while opening the model on the workspace then Visual Studio crashed or the network connection was lost. The exact error message is “An error occurred while opening the model on the workspace database”. For example you loose your network connectivity to the repository for a few seconds, then the SSAS Tabular object cannot be opened and you are somehow blocked.

How to fix the tabular model error message while opening it with Visual Studio?

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:

============================
Error Message:
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:

Go to the project folder and delete the .settings file.

For example if the SSAS Tabular Model still have the default name : Model.bim then 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 formulas.

Be the first to comment

Leave a Reply

Your email address will not be published.


*