Getting ODBC error [HY000]: 'Specified cast is not valid' while loading data from Mongo DB

[SyamKumar]

DB connected fine in the Power BI Desktop, getting errors while loading data from Mongo DB tables.

[v-chenwuz-msft]

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.

[SyamKumar · Accepted solution]

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