Error refreshing Data OLE DB or ODBC error

Power Query
1

After trying to try to refresh the data, I’ve got an error that it looks it is coming from the Date Table.

This file was working fine last time I used it (Friday)

I check my connection to the database and it is working fine.

I try to use previous version of the file and also bring the same error.

Any suggestion where to start?

Thanks, DNA-error Message

2
  1. Scroll down and see if there is any other error in a different query. If there is solve that error.
  2. If not check out the data types of the columns in your Dates query.
3

Hi @ezenunez, did the response provided by @Matthias help you solve your query? If not, how far did you get and what kind of help you need further? If yes, kindly mark as solution the answer that solved your query. Thanks!

4

Hi @ezenunez , we’ve noticed that no response has been received from you since the 22nd of March. We just want to check if you still need further help with this post? In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved.

5

Hi @ezenunez, due to inactivity, a response on this post has been tagged as “Solution”. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box.

We’ve recently launched the Enterprise DNA Forum User Experience Survey, please feel free to answer it and give your insights on how we can further improve the Support forum. Thanks!

6

Thanks Matias,
Since I was not sure what was the table that made problem, I have connected all of them and I solved the problem.
Thanks,