Register
Log In
Unanswered
Home
Power Query
Power Pivot
Power BI
February 23, 2017
Offline
when I try to get data text data file into powerquery, I notice that the column cointaining sale data has the wrong data type (ab).
I try to change the data type to currency and get errors lining from top to bottom of columns. I don't know how to fix this
November 8, 2013
Offline
Hi,
Without seeing the file, we cannot see what's the problem. You have to check if there are unprintable chars in your data. You can try the Clean and the Trim options from Transform tab, before changing the data type.
Most Users Ever Online: 57
Currently Online: Meyanui
18 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 651
Frans Visser: 210
David_Ng: 96
mey tithveasna: 71
A.Maurizio: 60
rathanak: 58
yhooithin05: 54
Anders Sehlstedt: 47
julian: 46
PaulFogel: 37
Newest Members:
Akshatraj Adig
Liesie Marais
Moet Lewis
Michelle Anderson
Veronica Gallego
krishnaraj r
Dharan Prakash Mishra
Md. Rahman
Lilian Vo
Jane Kumwenda
Forum Stats:
Groups: 2
Forums: 18
Topics: 935
Posts: 4405
Member Stats:
Guest Posters: 1
Members: 42350
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
