How to connect to an AAS model via Visual Studio Code again after it has been renamed

Question

I have an Analysis Services Model that was created on visual studio, which was then deployed onto Azure. I tried to rename this model via SQL Server Management Studio, and this seems to be fine and the new name appears when I view the model on the Azure Portal. (But when I view the properties of the model on SSMS, the ID field is still the old name which I can't change)

However, when I try to open the model (in tabular view) on visual studio again, I am getting the error: An error occurred while opening the model on the workspace database. Reason: Another 'Database' object has the 'Old_Name_Of_The_Model' ID.

The model is an import model, so preferably I'd want a way of accessing the project on visual studio without having to re-import the data. I have a backup of the model (Azure Blob Container), but I haven't tested this backup file yet.

Answer 1

Can you try to locate the .bim file in your project folder. Try to open it with a text editor like Notepad++ or Visual Studio Code and check the Database section.

You should find something similar to "id": "Old_Name_Of_The_Model".

Update the id with the new name to make it consistent with the new name you used in SSMS and Azure portal and save the changes.