Forum Discussion

TimoRiikonen's avatar
TimoRiikonen
Advocate V
3 years ago

PowerQuery diagnostics fails to calculate processor time because it uses wrong decimal separator

Root cause: In Finnish language decimal separator is comma instead of dot.

When we have text or undefined value "1.1" and we try to convert this to decimal we get an error, which I believe is how it should work. Conversion works from "1,1" correctly.

Problem is that PowerQuery performance diagnostics creates values with dot and then try to change these values to percentage. Changing to percentage works the same as changing to decimals: it gives an error.

Suggestion: Add locality settings to the percentage conversion so that it ignores report locality and always does the conversion with en_US settings.

 

I have an example Power BI file for verifying and testing this.

No RepliesBe the first to reply