Refresh error: The command has been canceled.. The exception was raised by the IDbCommand interface

[Anonymous]

Hi,

Recently i've been running into this issue where I am unable to schedule refresh or refresh my data from the Power BI online client.

My dashboards are connected to SQL and it has worked before. However now I keep getting the error message below when trying to refresh:

Last refresh failed: Tue Aug 14 2018 08:33:06 GMT+0800 (Singapore Standard Time) 
There was an error when processing the data in the dataset.Hide details

Data source error:	The command has been canceled.. The exception was raised by the IDbCommand interface.
Cluster URI:	WABI-WEST-US-redirect.analysis.windows.net
Activity ID:	9712ab71-9fbe-4939-b630-2b57c28fd182
Request ID:	fe788762-9ff6-484c-44ea-eedc6228eec1
Time:	2018-08-14 00:33:06Z

my gateway is an on premise data gateway (not personal) version number: 14.16.6697.

can anyone highlight what this EDbCommand interface actually does and why is there an exception raised by this module?

Much thanks

[v-danhe-msft]

Hi @Anonymous,

Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?

Regards,

Daniel He

[Anonymous]

My solution was to update the data gateway which seemed to fix the problem

[v-danhe-msft · Accepted solution]

Hi @Anonymous,

Based on my reserch, you coyld refer to below question.

1. Can you refresh your data in dashboard? If not, can you provide the error message that showed up in the Desktop?

2. How many queries (tables) in your model? Maybe some queries need much longer time to refresh. 

3. Can you carry out a manual refreshing in the Service successfully?

Please reference to these threads, maybe helpful. 

The-command-has-been-canceled

Error-refreshing-The-command-has-been-canceled

Schedule-Refresh-Processing-Error

Regards,

Daniel He