OLE DB or ODBC error

[ap360]

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.

[SaiTejaTalasila]

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.

[Wikkleyn_81]

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?