Forum Discussion
Solved
error, changing data type
Hello I have a column of numbers that was imported as a text. I wanted that changed to a Fixed Decimal Number. This needed to be the case in 2 columns. In both columns every cell converted a...
I accidentally posted this twice. Sorry. The other one has a screenshot.
Hello
I have the same problem without the % sign.
My numbers are correctly formatted as numbers in Excel but they appear as text in PowerBI and if I try to change the type, I have the "error"
Did you find the solution ?
THank you
Think I figured it out. Numbers dont like blank fields.
The columns must have a value of numaric. I had to repopulate a list with 0s
Brett