'SSAS Cube - Column cannot be processed (2B distinct values)

I recently encountered an error on an SSAS cube:

The JSON DDL request failed with the following error: Failed to save modifications to the server. Error returned: #The #<my_column># column of the #<my_table># table cannot be processed because it contains more than two billion unique values.  #..

I checked the cardinality of the column on Dax Studio and the number for that specific column amount to 18,205,900 which is way below 2 billions distinct values.

Do you have any idea on what could be the potential issue?

Thanks

sql-serverssasolapolap-cube


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions