Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote now!
Using the latest Power BI Desktop.
Followed the instructions to set up MongoDB ODBC BI Connector, and the ODBC driver.
I can connect to MongoDB, retrieve the collections. If I try to load one table, it loads eventually. Any more than one, I get the following error:
Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error] ODBC: ERROR [22018] [MySQL][ODBC 1.4(a) Driver][mysqld-5.7.12 mongosqld v2.14.5]. '.
and no tables will load. If it matters, the ODBC connection is connected to the MongoDB instance via a read-only user. I've read elsewhere that this is OK, as Power BI doesn't require write access. Would appreciate any pointers on how to resolve this!
Thanks.
Solved! Go to Solution.
Hi, @andrewt
Based on research, the 22018 error is related to encode, you can also check your database if any unicode string stored in your database.
Solved: powerBI Desktop - error returned when loading data... - Microsoft Power BI Community
Solved: Power BI to Aurora MySQL connetion - ODBC error - Microsoft Power BI Community
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @andrewt
Based on research, the 22018 error is related to encode, you can also check your database if any unicode string stored in your database.
Solved: powerBI Desktop - error returned when loading data... - Microsoft Power BI Community
Solved: Power BI to Aurora MySQL connetion - ODBC error - Microsoft Power BI Community
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 60 | |
| 59 | |
| 45 | |
| 17 | |
| 17 |
| User | Count |
|---|---|
| 115 | |
| 114 | |
| 38 | |
| 36 | |
| 26 |