Forum Discussion

PJOS_1's avatar
PJOS_1
Frequent Visitor
5 years ago
Solved

Prevent Power BI from changing imported data

Greetings all, I've scoured the web trying to see if someone has had a similar problem and I haven't found anything. My problem is actually really simple. I have a table in Excel that I import into i...
Need Help
  • PJOS_1's avatar
    PJOS_1
    5 years ago

    In my experience with this problem, I found that having it on or off didn't matter. What solved the problem for me though was to simply run TRIM() on all the values. Problem solved.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

PJOS_1 , Power bi will not take excel formatting, convert to number, and change decimal place and check , it might be the same number

or

In power bi reduce decimal place

or

Open power query, Right click and open the Advance editor and find the column, and change datatype to text

refer: https://www.youtube.com/watch?v=h0yLtceT0i4