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.

PJOS_1's avatar
PJOS_1
Frequent Visitor
5 years ago

It turns out that Excel apparently is willing to lie to you. I've formated those cells as text yet if I run a simple "ISTEXT" function, several of them come back "FALSE". What a headache.....

  • v-jingzhang's avatar
    v-jingzhang
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi PJOS_1 

    How about turning on the Type Detection option for this file? Based on my test, if I check Type Detection, the data shows well in Power BI. However, when I uncheck Type Detection, the result is the same as yours. It seems Type Detection feature can help solve this problem. 

    Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as the solution to help other members find it.

    • PJOS_1's avatar
      PJOS_1
      Frequent Visitor
      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.