Share via

Visual Studio 2019 (SSAS) - Error when trying to open my model

Tanner Yatsko 11 Reputation points
2022-08-17T22:03:59.19+00:00

The backstory: I work with SSAS and a tabular model via a VDI. The connection with my VDI went wonky and now there is a disconnect involving my tabular model.

I'm only trying to open my tabular model (.bim) via SSAS, and I keep getting the error that the Item 'column' already exists in the collection. I had no issues with opening the model between when that column was created (last week), and when I had the issues with connection to the VDI. I used the model almost every day in that timespan. From what I've read, it may be an issue with the integrated workspace, because multiple users work on this model. Any help is appreciated!

232087-image.png

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,291 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Tanner Yatsko 11 Reputation points
    2022-08-17T23:27:17.833+00:00

    I found the solution to this myself. I don't know why or how this issue began initially, but I right-clicked on Model.bim, went to its properties, and then switched the Integrated Workspace Mode from True to False, and then back to True. I was able to open the Model again.
    232146-image.png

    1 person found this answer helpful.
  2. Joyzhao-MSFT 15,596 Reputation points
    2022-08-18T09:39:38.157+00:00

    Hi @Tanner Yatsko ,
    I am glad to hear that your issue has been resolved. If you have any questions, please feel free to let me know.
    Best Regards,
    Joy

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.