Forum Discussion
ODBC problem in loading data
Hi Anonymoussss,
Thank you for reaching out to Microsoft Fabric Community Forum.
I would suggest considering the following approach to resolve the issue
- Instead of loading the entire dataset at once, try excluding the problematic column initially. Once the rest of the data is loaded, add the column separately and check if the issue persists.
- If possible, use the native MongoDB connector in Power BI instead of ODBC. The native connector is optimized for MongoDB and may handle Boolean values more effectively, avoiding the casting error.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Regards,
Vinay Pabbu
Hi AnkitKukreja
I think the problem is with the MongoDB atlas sql connector. I've tried loading that particular column separately and the error raises. If I ommit that column, then other columns load. The data is getting loaded if I download and use but I need latest data so I use import mode and refresh the data as using direct query does not support some transformation steps.
Thank You.
Hi Anonymoussss,
Since the issue is with the MongoDB Atlas SQL Connector, and the error occurs when loading just that column, the problem is likely due to how the ODBC driver handles Boolean values.
Some ODBC drivers struggle to interpret Boolean data types correctly, leading to type mismatch errors.
Try converting the column at the source level before it reaches Power BI.
Regards,
Vinay Pabbu