SSAS to Power bi Percentage symbol issue

[sushil9084]

Hi All,

I am connecting to SSAS with live connection from Power BI. The issue is, we have some measures which are in % .

when i am trying to create a chart using this measure, it is treated as a text field..

I understand that this has to fixed from SSAS end. but we not able to get rid of this issue.

I appreciate any kind of help on this issue....

Thanks,

Sushil

[DSimma]

Edit the query and do a find and replace to replace the % with nothing, then you can change the format of the column to number with percentage formats and it will show correctly. You also might need to do a divide by 100 if the 100 turns into 10000%.

[Seth_C_Bauer]

@DSimma - you can't change data types and or format anything in the Desktop when you are connected to SSAS with live connection. The modeling is purely contained within the SSAS model.

@sushil9084 What is the format that you have the column set as in the Model? I've never encountered this when my column is set to a percentage format.

[BarryB75]

@Seth_C_Bauer  I've got an odd one... when I connect live to the cube, it comes over as percentage.  when I import, it comes over as text and I have to reformat it.   What causes that?

[Seth_C_Bauer]

@BarryB75 I would imagine it has something to do with how the Desktop is auto detecting the datatype. If there is a percentage symbol in the value it must be translating the value to text. As opposed to the live connection, when the Desktop just acts as the connection to the cube.