Error connecting Power BI desktop to MOngo database

[Šarka]

Hi all,

I have working connection to Mongo DB, but some collections fail to load and I see this error. 

THank you for help, any advice appreciated.

[Šarka · Accepted solution]

SOLVED: At the end I found out that I had a wrong ODBC driver installed and it was not working for some of the collections.

[Šarka]

Thank you, I am aware it is some invalid charakter but not sure how to fix it. 

[v-zhangtin-msft]

Hi, @Šarka 

Please check out the following links hope it helps.

Solved: MOngodb to Powerbi Integration - Microsoft Fabric Community

Solved: powerBI Desktop - error returned when loading data... - Microsoft Fabric 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.

[lbendlin]

Appendix A: ODBC Error Codes - ODBC API Reference | Microsoft Learn

22018

Invalid character value for cast specification