Forum Discussion

ap360's avatar
ap360
Frequent Visitor
2 years ago

OLE DB or ODBC error

Good day,

 

In the power query, all my tables are refreshing successfully. Once I am on my dashboard and try to refresh, I get the following error:

I read about a previous solution of unchecking the Internet Protocol Version 6 but, this did not work. I also saw that it might be due to a column having the wrong data type but, this also did not work. 

 

Is there any other solutions that you'd recommend?

 

Thank you.

Need Help

2 Replies

  • Wikkleyn_81's avatar
    Wikkleyn_81
    Super User
    2 years ago

    Hi ap360 Those error messages are unfortunately very generic and the best would be to go the the specific query. Check every step for any errors. Are there any additional steps that might fail if there is a data type issue?

  • SaiTejaTalasila's avatar
    SaiTejaTalasila
    Super User
    2 years ago

    Hi,

     

    Please check in which table that issue is occurring.

    Go to transform data>view>turn on column quality and check all your applied steps one by one for any errors.

    Check whether you have any null values in your date/time columns and replace null null values with some date and check.

     

    I hope with the above steps you will be able to find the errors.