The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
I am new to power bi. I have a column which have decimal values. But, the datatype is text. When I tried to convert the datatype to decimal power-bi query editors throws below error.
DataFormat.Error: We couldn't convert to Number.
Details:
−0.38
(note: It happens to only negative numbers)
Please help
Solved! Go to Solution.
I have a feeling that that "−" character isn't same as "-". As you can see, it's a bit wider. Did you get from Web.Page? Maybe you can do "Right click on columns > Replace Values" and replace "−"s with "-"s.
Hi,
I am new to power bi. I have a column which have decimal values. But, the datatype is text. When I tried to convert the datatype to decimal power-bi query editors throws below error.
DataFormat.Error: We couldn't convert to Number.
Details:
−0.38
(note: It happens to only negative numbers)
Please help
As I tested, PowerBI can certainly convert the text "negative numbers" into a negative number, so there's something else going on here.
I import the data into Power BI as following screenshot.
Please check the negative sign in the string if there is actually some kind of Unicode character, or that there's something which looks like a digit in the text but is actually a letter? Would you be able to share your data with us for further analysis?
Best Regards,
Angelia
Thanks Angelia & Arify,
The issue is with "−" charactor. I replaced it with "-" . Now Everything works fine
I have a feeling that that "−" character isn't same as "-". As you can see, it's a bit wider. Did you get from Web.Page? Maybe you can do "Right click on columns > Replace Values" and replace "−"s with "-"s.
Thanks arify,
it worked for me as well.
Kind Regards