Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
ap360
Frequent Visitor

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:

ap360_0-1716293691026.png

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.

2 REPLIES 2
SaiTejaTalasila
Solution Sage
Solution Sage

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
Resolver III
Resolver III

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?

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.