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.

v-jingzhang's avatar
v-jingzhang
Community 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.