Can't change the data type of column when using analysis services

[nosaj03]

Hello all!

Im connected to a tabular model using analysis services and when create tables or matrices, it does not give me the option to change the data type in the modeling tab. Everything is grayed out. 

My data in Visual Studios is formatted as whole numbers but when updated in Power BI, they have decimals. I've been working around it by creating measures and formatting the data type through there but I don't want to have to create duplicate field values and would just want to modify in Power BI. 

Any help would be greatly appreciated. 

[Watsky]

@nosaj03 when you say the options are grayed out which options are grayed out? Can you screenshot it? 

[nosaj03]

@Watsky cant send a screen shot but basically doesnt allow me to change the format. Its defaulted to the decimal number and I can't click the drop down to change it. 

[Watsky]

@nosaj03  is the data coming in as a live connection or import? If it's a live connection then that's the issue. You can't modify the format on a live connection.

You should be able to connect using Direct Query and the SQL Database connector.

https://community.powerbi.com/t5/Desktop/Analysis-Services-Changing-Data-Type/td-p/560885

Did my answer(s) help you? Give it a kudos by clicking the Thumbs Up! ?
Did my post answer your question(s)? Mark my post as a solution. This will help others find the solution.