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