Limit on number of measures in SSAS Tabular model table

Question

Hi Experts,

I am using SQL Server 2019 for SSAS Tabular Model and use Microsoft Visual Studio Community 2019 Version 16.6.5 for Tabular model development.

I have a Measures table (table with a single column hidden) and all my measures are under this table. I have about 100 measures in this table and now I cannot add more measures. Visual Studio GUI interface does not show any more rows to add measures.

Is there a limit in number of measures that can be added to a Tabular model table?
How can I add more measures (more than 100) to a table?

Thanks,
Anand

Answer 1

Is there a limit in number of measures that can be added to a Tabular model table?

No I've seen models with tens of thousands of measures in a single table. What you are seeing is just a limitation of the SSDT user interface

How can I add more measures (more than 100) to a table?

To do this in SSDT you would probably have to add another dummy column to your measures table.

If you use a tool like Tabular Editor it does not have this limitation.

Answer 2

@Darren Gosbell ,
Thanks a lot for the prompt answer.
Added a another column and that did the trick.

Answer 3

Add an empty column would give you more grid to add your measure. Also you could create an empty table to organize all your measure as demonstrated in Organizing Your Measures With a “Dummy” Table