Forum Discussion

sushil9084's avatar
sushil9084
Regular Visitor
10 years ago

SSAS to Power bi Percentage symbol issue

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 a...
Anonymous's avatar
Anonymous
Not applicable
10 years ago

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.

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Anonymous  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?

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    Anonymous 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.