Forum Discussion

ThaysMaia's avatar
ThaysMaia
Regular Visitor
8 years ago
Solved

Number/Date format using direct query to SSAS

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.

Need Help
Tips and Tricks
  • JoHo_BI's avatar
    JoHo_BI
    8 years ago

    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. 

2 Replies

  • JoHo_BI's avatar
    JoHo_BI
    Responsive Resident
    8 years ago

    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.