Issue with currency rates decimal formatting from XE.COM to Power BI

[Medmbchr]

Hi I would like to import currency exchange rates from XE.COM using a web import, the result normally should be as follow for MAD: USD US Dollar 0.09339564850488953 10.707136959894305 However I get numbers without decimals. Is there a way to counter this?

[TomasAndersson]

Could you share your query and/or how it looks in the Power Query Editor? Could it be that the Data Type is set to integer or something similar?

[Medmbchr]

Hi @TomasAndersson 

Here is from where I get my data: https://www.xe.com/currencytables/?from=MAD

Here is how it looks on PowerQuery after importing from the web data source, I think something has to do with formatting:

[TomasAndersson · Accepted solution]

Looks like the query ignores the decimal point and returns the rates as very large numbers instead. It's likely due to your language/locations settings, where your Power BI is set to recognize "," and not "." as as decimal separator.

You could go to your settings and change that. But if you don't want to (it would affect the entire report), this might work:

- In the Power Query editor, go to the applied step "Navigation"

- Select the columns with the rates, find the button "Replace Values" and replace . with ,
- Go the the applied step "Changed Type"

- Select the columns with the rates, find the button "Data Type" and choose decimal number
 
I don't get this problem since I have different settings and my program recognizes "." as a decimal point, so sorry for not giving a better step-by-step with pictures.

[Medmbchr]

It worked, I didn't think of these regional settings! Thank you