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

Data refresh error:The exception was raised by the IDbCommand interface

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 (May 2018).

 

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

 

Much thanks

2 REPLIES 2
Ross73312 Super Contributor
Super Contributor

Re: Data refresh error:The exception was raised by the IDbCommand interface

From what I understand it is this:

 

https://msdn.microsoft.com/en-us/library/system.data.idbcommand(v=vs.110).aspx

 

or something similar at least.

 

I'd suggest using Power BI desktop and doing a manual refresh of the data model yourself.  You should get a more detail explaination through there.


   

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

Proud to be a Datanaut!


   


li783 Frequent Visitor
Frequent Visitor

Re: Data refresh error:The exception was raised by the IDbCommand interface

It is worth to check all your data queries are using the same format of setup especially using SQL as Data Source.

 

A max up setup will cause the exception of IDbCommand interface.

 

https://community.powerbi.com/t5/Report-Server/SCHEDULED-REFRESH-ERROR/m-p/724799#M10744

 

Hope this could solve your problem.

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Users Online
Currently online: 277 members 2,791 guests
Please welcome our newest community members: