cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Mark598 Frequent Visitor
Frequent Visitor

ODBC Refresh schedule not working

Hi,

 

I have been struggling with the ODBC refresh schedule for weeks now. Have read a lot of issues here but not found a solution for mine. Maybe someone can help me or point to a solution. I have my gateway set up to a server that is always on but somehow the refresh schedule most of the time does not work. On demand refresh works fine and has no issues but when I schedule it then the problems start and I only get error messages:

 

1.PNG

 

As you can see in the picture I have one scheduled refresh that worked. Rest of them failed and all On demand refreshes that I tested also worked.

 

My gateway is configured correctly and status is green and always on. I have tested to put schedules during the working hours when I am 100% sure the server is on and working but still the same thing. Scheduled fail, on demand work. I would really appreciate some help on this. At the moment I cannot use any of my reports because all I do is update them manually which takes a lot of time.

 

A few pictures of my setup:

 

2.png3.png

3 REPLIES 3
Super User
Super User

Re: ODBC Refresh schedule not working

Hi there

If you had to click on "Show" what does that say?

Did I answer your question? Mark my post as a solution!

"Proud to be a Datanaut!"


Power BI Blog
Mark598 Frequent Visitor
Frequent Visitor

Re: ODBC Refresh schedule not working

4.png

Table is different in all of the refresh attempts.

Super User
Super User

Re: ODBC Refresh schedule not working

Hi @Mark598 

 

It appears that the query is taking to long to get the data back and is timing out.

 

Possibly see if you can increase the timeout values?


Did I answer your question? Mark my post as a solution!

"Proud to be a Datanaut!"


Power BI Blog

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 341 members 3,858 guests
Please welcome our newest community members: