Number/Date format using direct query to SSAS

[ThaysMaia]

Hi,

I'm using direct query to SSAS and the Year field has decimal places.

The formatting on the modeling tab is greyed out and I cannot use that.

Any ideas?

Tks.

[JoHo_BI · Accepted solution]

Hi, 

You need to make sure the data type in your SSAS model is set to integer rather than decimal. All modelling changes when connected to SSAS need to come from the model file rather than inside Power BI.

All the best, 

Joe. 

[ThaysMaia]

I imagined that. Tks.