Forum Discussion
Getting ODBC error [HY000]: 'Specified cast is not valid' while loading data from Mongo DB
DB connected fine in the Power BI Desktop, getting errors while loading data from Mongo DB tables.
As I have been using the latest version of Power BI Desktop, the proposed solution did not resolve the issue. In order to find the problem, I debugged every column in the table. There was a blank value in one of the date columns. The problem has been resolved after I corrected it.
3 Replies
- v-chenwuz-msft
Community Support
Hi SyamKumar ,
Please update your desktop to the latest version, and the error maybe will be gone.
Download Microsoft Power BI Desktop from Official Microsoft Download Center
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
As I have been using the latest version of Power BI Desktop, the proposed solution did not resolve the issue. In order to find the problem, I debugged every column in the table. There was a blank value in one of the date columns. The problem has been resolved after I corrected it.
- v-chenwuz-msft
Hi SyamKumar ,
I'm glad your problem was solved, please mark your answer as a solution so that people with the same problem as you can find the answer quickly.
Best Regards
Community Support Team _ chenwu zhu
