Numbers get rounded off

Question

I have an excel file that looks as follows:

When i refresh it in power bi, it automatically gets rounded off as follows: (Region b- metric re - 31st oct: 57.4)

The value column is a decimal number only :

I do not want the numbers to round off and refresh as it is. What can be done?

Thanks!

anonymous · Answer

Christann&nbsp;Oh i am not sure. I did not do anything special in the query editor&nbsp;&nbsp;&nbsp;Is it the highlighted part? I'm not sure if i have to change anything or to what to change anything to

christann · Answer

Could you be rounding the numbers in the query editor?

christann · Answer

I am not sure what would be wrong then. I would suggest that you try contacting Microsoft PowerBI Support on this question.

v-frfei-msft · Answer

Hi&nbsp;Anonymous,
&nbsp;
Based on my test, I cannoy reproduce your issue here by using the latest version of Power BI dekstop :2.63.3272.40161 64-bit (October 2018).
&nbsp;
Could you please update your Power BI desktop and turn the option off to try again?
&nbsp;