Unable to apply query changes - OLE DB or ODBC error

[valsdott]

Hello,

I am preparing a Power BI file and I have connected to a xlsx or csv file on my local hard drive server to import a data table. I go through all the steps and prepare my table without problems. But when I want to apply and close the query editor the following error comes up:

"Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataFormar.Error] We couldn't convert to Number..'."

Can anyone give me an idea of what the issue is? The xlsx or csv files are downloaded results from a surveyMonkey survey. They do not contain a lot of data.

Thanks,

[v-danhe-msft]

Hi @valsdott,

Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?

Regards,

Daniel He

[valsdott]

Hi Daniel,

no the problem still persists. In my final table there are no numerical columns, I have converted all to text.

What I ended up doing was import the data from the Excel file into another Power Bi file which contains other data as well. And for some strange reason it didn't cause the error even if I made the exact same conversions to the table.

How can I sent you the files to look into this?

Thank you,

Rebekka

[v-danhe-msft]

Hi @valsdott,

For your description, it sounds like there is some non-numeric data in some of the rows that you were previously converting to number. I'd recommend you examine the source data to determine where the errors are coming from, remove or fix up the problematic rows, and then re-apply the number conversion or could you please share the xlsx or csv file if possible?

Regards,

Daniel He