Forum Discussion

StatsChick's avatar
StatsChick
Frequent Visitor
4 years ago
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 ...
Need Help
  • StatsChick's avatar
    StatsChick
    4 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi StatsChick ,

Please navigate to Power Query Editor page first, click the "Advanced Editor" option in Home ribbon. Then find the applied step "Changed Type", change the data type of column ID from Number to Text just as below screenshot.

If the above method is not working, please provide some screenshot with data and error message(exclude sensitive info) or your sample pbix file if it is convenient. Thank you.

Best Regards

StatsChick's avatar
StatsChick
Frequent Visitor
4 years ago

Thank you. This got me pretty far, but I'm still getting an error. I'm sure it's a syntax thing. What do you think?