Power query does not recognize decimal separator

Article
2018-06-19

Question

_{Tuesday, June 19, 2018 12:07 AM}

My query has a column with decimal numbers, after refresh the query then the decimal separator (.) does not appear. This cause that e.g. 24.733 is shown as 24733.

This error causes the report to be useless.

This occurs in some Win10 computers with Office 365 (2016).

All replies (2)

_{Wednesday, June 20, 2018 8:49 AM}

Hi,

What's the data source type?

Please test with the same data source in other computer and check if this problem can be reproduced. Then check if this problem is related to data source or Power Query in Excel.

I also suggest you go to Control Panel- Region- under Formats tab select Additional Settings- please check the Numbers and Currency formats for Windows.

Please provide more information about your problem and I'm glad to hlep you.

Regards,

Emi

Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact [email protected].

Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Teams.

_{Monday, June 25, 2018 9:25 AM}

Hi,

Just checking in to see if the information was helpful. Please let us know if you would like further assistance.