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 Anonymoussss,
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.
Regards,
Vinay Pabbu
Hi Anonymoussss,
May I ask if you have gotten this issue resolved?
If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.
Regards,
Vinay PabbuHi @Anonymoussss,
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.Regards,
Vinay Pabbu