CODEWITHSUNDEEP
visual-studio-2015ssassql-server-data-toolsssas-tabular
z33Will
z33Will

Reputation: 49

Tabular Model Measures Not Populating

Measures Grid Screenshot

So I'm working in a Tabular Model Solution using SSDT/Visual Studio-15. None of my measures or calculated columns have any errors. I'm having a very difficult time working in the model because my measures in the measures grid don't always populate. They just show me the name of the field and not the actual value. I have tried doing a restart, reconnecting the model to SSMS and every little trick that I was able to find online. Why don't my measures populate 100% of the time? I have other models that were built before I started this job and they populate more than the subject model but still less than 100% of the time.

Upvotes: 0

Views: 519

Answers (1)

userfl89
userfl89

Reputation: 4810

The Tabular model that you're using in SSDT in the workspace database, which is essentially an in-memory copy of the model that you use in development, as opposed to where you're deploying the changes to. You've probably noticed it in SSMS, as its name is the model name plus your username and a GUID. Where and how it's stored will depend on if a workspace server or integrated workspace is used, and the configurations from there. To populate the measures and calculated columns in SSDT, process the cube from within SSDT.

Upvotes: 1

Related Questions