cancel
Showing results for 
Search instead for 
Did you mean: 

Aggregation options missing from field well columns

We use SSAS tabular models via a live connection to access our data.

 

A user has recently noticed that the option to do a simple aggregate (i.e. count) from the field well is not present in some of our models. I've compared the models where it is and isn't present and in both cases the field is a text format with "default summarization" set.

 

The only difference between the models is the compatibility Level which is 1400 for the model which works and 1500 for all other models. I cant find any reference to this sort of issue anywhere else.

 

Below are screenshots of the options I see in the 2 models from Desktop.

 

 

issue.PNG

Status: New
Comments
Community Support

@Takezo ,

 

This should be an issue on ssas side. There should be some difference between 1400 and 1500, please refer to doc below:

https://docs.microsoft.com/en-us/analysis-services/tabular-models/compatibility-level-for-tabular-mo...

 

Regards,

JImmy Tao

Regular Visitor

I have the same problem. Today I have seen that a PBIX does not see the options, but in a previous version of the same file from a week ago, the aggregation options are seen.