Forum Discussion
Mongodb Error while fetching data, Failed to save modifications to server
I am connecting to mongodb collection which has 6 million documents, i am able to connect to mongodb but when loading the collection it fetches around 70,000 records and then gives an error
Failed to save modifications to the server. Error Returned: OLE DB or ODBC error: [Datasource ERROR] ODBC ERROR[22018][Mysql][ODBC 1.3(a) Driver][mysqld-5.7.12 mongosqld v2 13.4]
what is causing this error and suggestionst to resolve it.
3 Replies
v-lid-msftCommunity Support
Hi Anonymous ,
Could you please check the installed ODBC driver / DSN, if it is ASCII driver, could you please try to use the Unicode ODBC driver / DSN?
Please refer to this similar thread: https://community.powerbi.com/t5/Power-Query/ODBC-Problem-with-mongoDB-BI-connector-MySQL/td-p/377135
Best regards,- v-lid-msft
Hi Anonymous ,
How about the result after you follow the suggestions mentioned in my original post?Could you please provide more details about it If it doesn't meet your requirement?
Best regards, - v-lid-msft
Hi Anonymous ,
Does this issue have been resolved?Could you please provide more details about it If it still not be resolved? Please don't contain any Confidential Information or Real data in your reply.
Best regards,