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...
DSimma's avatar
DSimma
Advocate IV
10 years ago

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

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