data type change analysis services

Hi,

Am looking for ways to be able to change the data type of a Dimension attribute (like Resume number) from numerical to text data type. That will allow me to analyze some related facts.

I dont see any option as such.

Tool used- Power BI

Source - Analysis Services

mkatipal, In Power BI Desktop, click on 'Edit Queries' under the Home tab, then in the opened Query Editor window, you select the column by clicking on it, then change the 'Data Type' (under Home tab) to Text.

Hi mkatipal,

To change the data type, you have a couple options. You can, in the Data view (left side button that looks like a table), click on the column you would like to change the data type, then select the Modeling tab and choose the "Data Type" dropdown in the formatting section.

Alternatively, go into the Query Mode by clicking on the Home tab at the top, then "edit queries". From there, the "transform" section will have a Data type dropdown you can select.

Hi mkatipal,

Could you please mark the proper answer as solution or share the solution if it's convenient for you? That will be a big help to the others.

Best Regards!
Dale

Hello,

I am also having this problem. I prepared a report with SSAS live connection and I need to change one column's data type to "Barcode", but I can not do it at this moment.

Did you get the proper solution?

Best regards.