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 ,

I found two cases similar to your problem, please check the solution in the following links. Hope they also can help you solve the problem.

Failed to save modifications to the server. Error returned: ' OLE DB or ODBC error:

Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error

If the above methods still can't solve your problem, please share with us your sample pbix file and screenshot of the original data source data (excluding sensitive information).

Best Regards

StatsChick's avatar
StatsChick
Frequent Visitor
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.