Forum Discussion
Solved
PowerBI Reads Text as INT
Hi, I'm loading data that has an ID number which, severval rows down, has a "-A" in it. PowerBI keeps returning an error: "Failed to convert ID to INT." I keep thinking that using TRANSFORM would ...
Thanks for these links. I found them, too. They both confirm my finding that Power BI does not let me convert field types as they are read. I have to go back into my original server and re-sort the data so that Power BI sees its proper type. Taking off the "auto detect type" flag didn't work, and I don't have access to tell Power BI to read 1,000 rows to identify type. So I'm stuck reworking the original data.
I'm sorry for being dense, but I need to keep the column. I seem to be missing where you put that statement. Thanks for getting back to me so quickly.
Sorry, you have to share the screenshots, as I already provided the instructions.
I updated my previous reply. you need to remove the column name in the data type conversion step.