Forum Discussion
pq0310
1 year agoRegular Visitor
refresh error
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 mod...
- 1 year ago
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
pallavi_r
1 year agoSuper User
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