Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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,
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
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
129 | |
106 | |
106 | |
86 | |
72 |