Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am trying to import a mixed (number and text) column from Excel into PowerBI, due to the start of the column all being numbers PowerBI has chosen the column type as numeric. However when I change type to text the values 1.1 and 2.2 are being incorrectly converted to 1.1000000000000001 and 2.2000000000000002 respectively.
I have tested with a small sample set of data and am able to easily replicate see below:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.