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

4 Replies

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