Solved: refresh error

pq0310 · ‎07-14-2025

Hello , thanks for help

When I refresh, I get the above error box.

What happens if I get an OLE DB or ODBC error?

I have previously created a query again and the proceeded to connect the models.

pallavi_r · ‎07-14-2025

This error occurs if the data type is not correctly mapped. So in the power query editor check each column and ensure it changed to appropriate data type. Especially check the date fields which are generally not correctly changed to date type and gives this error.

If this post helps, please accept this as a solution. Appreciate your kudos.

Thanks,
Pallavi

View solution in original post

v-echaithra · ‎07-21-2025

Hi @pq0310 ,

Just checking in to confirm that your issue has been resolved. If you have any remaining questions or need additional assistance, feel free to reach out, we're always here to help.

Best Regards,
Chaithra E.

v-echaithra · ‎07-18-2025

Hi @pq0310 ,

We would like to confirm if you've successfully resolved this issue or if you need further help. If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.

Thank you for your patience and look forward to hearing from you.
Best Regards,
Chaithra E.

pallavi_r · ‎07-14-2025

Hi @pq0310 ,

This error occurs if the data type is not correctly mapped. So in the power query editor check each column and ensure it changed to appropriate data type. Especially check the date fields which are generally not correctly changed to date type and gives this error.

If this post helps, please accept this as a solution. Appreciate your kudos.

Thanks,
Pallavi