Hello,
I'm using an MS SQL server as datasource. From this server I load a column formatted as text in which I have "real" text, numeric entries (decimal) and empty cells. Only the numbers are what I want to display in a chart, so I remove the empty cells and the text values by the following steps in the query editor:
= Table.TransformColumnTypes(#"Expanded mytable",{{"MyColumn", type number}})
= Table.RemoveRowsWithErrors(#"Changed Type1", {"MyColumn"})
Now the problem starts, I see the column exactly as I need it formatted as decimal numbers and in Power BI Desktop everything works fine. However as soon as I publish the report to the service and refresh my dataset once through the gateway, the commas that I use as separators are lost - so 0,25 turns into 25 and 6,5 turns into 65 in my visualization.
If tried changing the locale type of my column like
= Table.TransformColumnTypes(#"Changed Type", {{"MyColumn", type number}}, "de-AT")
Other things that I tried was adding a new column in which I did the tranformations and changing the locale, everything without success. I guess the service just doesn't seem to realize that I use comma-separted decimals.
Does anyone have an idea what I can do? In the rest of the same report as well as all other reports everything works and I've not encountered the problem anywhere else, without messing around with locale format at all.
