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."

     

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi xieyifan2008,

 

I think it is because Power Bi is automatically detecting the data type of the column. Can you try disabling the below highligted options and see if it helps..

 
 

Let me know if this works..

 

Thanks,

Sneha

xieyifan2008's avatar
xieyifan2008
Frequent Visitor
6 years ago

Thanks for your suggestion.

Unchecked two automatic options. In Power Query, there is just no automatic type change. When I insert the type change from any to text, it keeps the same result.