Query Timeout on Update

[B_Albuquerque]

I'm getting the following error trying to update my Data:

Last refresh failed: Mon Oct 30 2017 12:38:25 GMT-0200 (Horário brasileiro de verão) 
The gateway operation has been cancelled explicitly by the user or from a timeout.Hide details

Cluster URI:	WABI-BRAZIL-SOUTH-redirect.analysis.windows.net
Activity ID:	eb9fe926-5125-4ffa-a57e-da4512f143d4
Request ID:	f255f4b8-0a73-68b2-9e82-aad0a74acaeb
Time:	2017-10-30 14:38:25Z

This answer don't help me at all. I can update the data using the Refresh button on the PowerBI Desktop without any problem, reviewed the Gateway instalation, but nothing worked.

[v-jiascu-msft]

Hi @B_Albuquerque,

1. Is this a message of scheduled refresh or manual refresh?

2. Did you try to refresh it manually?

3. What's the size of your dataset?

4. Please upgrade the Gateway to the latest version.

Best Regards!

Dale

[B_Albuquerque]

1- Both refreshes fail. I can ONLY refresh data using que Refresh button inside the PowerBI Desktop.
2-  In the Datasets tab, yes. It fails everytime.

3- About 600Mb.
4- Everything is up to date.

[v-jiascu-msft]

Hi @B_Albuquerque,

1. Check the status of Gateway and credentials from the Settings of the Service;

2. Check the status of refresh history if the time duration is about 2 hours.

3. I think the main cause could be the size of the dataset and the quality of the bandwidth.

4. If they are all fine, please create a support ticket here: https://powerbi.microsoft.com/en-us/support/pro/.

Best Regards!

Dale