Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

kyr

The gateway operation has been cancelled explicitly by the user or from a timeout - MY SQL

Submitted by on ‎07-26-2017 04:04 AM

Hello,

 

Our report - which is based on MY SQL Queries - seems to experience difficulties regarding the scheduled refresh. This is the error that we got back: 

If anyone can offer any advice or provide further information that would be highly appreciatedGateway Refresh ErrorGateway Refresh Error

Status: Needs Info
See more ideas labeled with:
55 Comments (55 New)
Comments
MyraMa
Advocate II
Advocate II
‎12-13-2017 01:09 PM

I have to say the error message is quite misleading. I got the same issue. But it is actually because one of data tables failed validation. After I fix my data issue, it's back to normal refreshing. 

If your report was refreshing fine before but all of a sudden doesn't work, I suggest you should try to recall what has been changed and try to find out the problem of your data sets. But the cause might be various. 

All the good luck!

 

Cheers

Myra

 

dniedrauer
Resolver I
Resolver I
‎12-14-2017 10:01 AM

I spoke with support and found out it was because it draws from a View that loads very slowly (only 6 rows/second), so it times out eventually. The solution was to include fewer columns in the import, and that resolved the issue. 

Anonymous
Not applicable
‎12-27-2017 01:12 PM

This has been a very frustrating few days before and after Christmas figuring out why a dataset refreshes fine in Power BI Desktop but fails on the cloud service with the useless/deceptive message "The gateway operation has been cancelled explicitly by the user or from a timeout." All our time has been spent chasing down the many different possibilities listed on these now 6 pages of comments. But it wasn't a gateway or relationship issue. It took me rebuilding the dataset from scratch one table at a time, publishing to the service each time I added a table, then refreshing from the service, to find the culprit table, but I was still getting the wrong "timeout" message. So I created a dataset with just the one faulty table, and the error message finally changed to the helpful "not a legal OleAut date" message. Then, thanks to these guys, it was a quick fix to handle years 0016 and 0017 from the ERP.

k1wong
Regular Visitor
‎01-03-2018 06:05 PM

We are facing the same issue.

muneern
Frequent Visitor
‎01-08-2019 08:53 AM

Hi All,

 

I had the same problem -- but wasnt able to easily identify the root cause, since there were many dates that were at extreme ends of the range (e.g. Year 0001 or year 9999)

 

This is what I did to fix it:

  1. Added a custom column in the with the following formula:
    NewColumn = Number.From([Due Date])
  2. Convert custom column to decimal number
  3. Sort the table by this column

 

This then gave the following error, which I could use to identify the problematic records in the table:

Date Error.png

 

I hope this helps someone else.

 

 

Idea Statuses