Tag: SSMS

Data Engineering

SSAS Integrated Workspace: Failed to save modifications to the server. Error returned: ‘The column has invalid bindings specified.’

tonielook2 Comments

Problem:

While try to open Model.bim, error message:

Check in VS it’s using integrated Workspace:

Solution:

Connect via SSMS:

Delete the integrated workspace database: “db”

Open the model again from VS, no error message now.

Check again from SSMS, the integrated workspace database: “db” automatic generate again.

Reference:

  1. https://docs.microsoft.com/en-us/archive/blogs/analysisservices/introducing-integrated-workspace-mode-for-sql-server-data-tools-for-analysis-services-tabular-projects-ssdt-tabular
  2. https://docs.microsoft.com/en-us/analysis-services/tabular-models/workspace-database-ssas-tabular?view=asallproducts-allversions