Forum Discussion

xieyifan2008's avatar
xieyifan2008
Frequent Visitor
6 years ago
Solved

Strange Data Type Conversion from Number to Text

Hi, I have a table in Excel file and all the cells are General data type. When I import to Power BI through query and change data type to Text, the result is strange. Can someone help ...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    6 years ago

    Hi xieyifan2008 ,

     

    I got response from PG:

    "This is by design. Numbers in Excel use floating point, so certain values can't be represented with full precision.

    We apply the same display rounding that Excel uses when rendering the preview tables that contain numbers. But if you click on a cell you can see the full (non-rounded) value.

    If you convert the column to Text (as this customer did), you get the full non-rounded value."

     

     

v-frfei-msft's avatar
v-frfei-msft
Community Support
6 years ago

Hi xieyifan2008 ,

 

I got response from PG:

"This is by design. Numbers in Excel use floating point, so certain values can't be represented with full precision.

We apply the same display rounding that Excel uses when rendering the preview tables that contain numbers. But if you click on a cell you can see the full (non-rounded) value.

If you convert the column to Text (as this customer did), you get the full non-rounded value."

 

 

xieyifan2008's avatar
xieyifan2008
Frequent Visitor
6 years ago

Thanks for your feedback.

It's bacause of the precision of binary. I understand now.