topic Re: SSAS to Power bi Percentage symbol issue in Developer

SSAS to Power bi Percentage symbol issue

sushil9084 — Mon, 30 May 2016 05:21:03 GMT

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

Re: SSAS to Power bi Percentage symbol issue

DSimma — Tue, 31 May 2016 18:03:24 GMT

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

Re: SSAS to Power bi Percentage symbol issue

Anonymous — Tue, 31 May 2016 18:12:04 GMT

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

Re: SSAS to Power bi Percentage symbol issue

BarryB75 — Tue, 14 Jun 2016 22:06:48 GMT

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

Re: SSAS to Power bi Percentage symbol issue

Anonymous — Wed, 15 Jun 2016 01:35:01 GMT

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