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

SCHEDULED REFRESH ERROR

I have searched for any resolutions regarding scheduled refresh errors but haven't read any.  I am getting the following:

 

Credentials are required to connect to the SQL source.

The exception was raised by the IDbCommand interface.
[1] -1055784828: The database operation was cancelled because of an earlier failure.
[2] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface.

 

I have refreshed and reentered the the credentials multiple times to no avail.  This is only happening with one of my reports.  All other reports are refreshing as expected.

7 REPLIES 7

Re: SCHEDULED REFRESH ERROR

I solved a similar issue recently with a very similar error message.

 

In that case, one of the data sources in the report tried to connect at the server level, then the second step connected to the specific database/table. The account we use on our server only had permissions against the specific database therefore the refresh was failing. Everything worked when opening the report in PBI Desktop, as analysts have read permissions at the server level, so the issue was not obvious to find.

 

Not sure if this helps in your case, good luck in fixing the issue!

Highlighted
MonicaElizondo Regular Visitor
Regular Visitor

Re: SCHEDULED REFRESH ERROR

Hello!! Im having the same issue, 

When I change the load to incremental refresh in the Desktop, then I cant update in the Service.

 

Are you found some solution?

 

Greetings

Monica

Menolly Frequent Visitor
Frequent Visitor

Re: SCHEDULED REFRESH ERROR

Exactly the same.

Refreshing works in desktop, and in service with standard refreshing. But fail when trying to update with incremental refresh.

Re: SCHEDULED REFRESH ERROR

Datasource connectionstrings in PBRS are case sensative. 

 

Make sure your data source connections in Power Bi Desktop are correct. 

 

 

Menolly Frequent Visitor
Frequent Visitor

Re: SCHEDULED REFRESH ERROR

Already checked.

I first had a report already published in PBI services,  that I wanted to upgrade with the incremential refresh method.

It was working perfectly on desktop and on service before. Crashed after modifying for incremential refresh.

Works again if I turn off incremential refresh.

 

I checked database access directly in PBI services, and everything is fine.

 

I tried on another report, same issue.

smelei Frequent Visitor
Frequent Visitor

Re: SCHEDULED REFRESH ERROR

We've had occasional issues when we've modified the datasource configuration of existing reports. 

In most cases, this was resolved by deleting and then re-deploying the report. On a few occasions even this failed with the only work-around being to re-upload the report with a slightly different name

li783 Frequent Visitor
Frequent Visitor

Re: SCHEDULED REFRESH ERROR

Power BI accepts both (ServerName) and (ServerName:Database) as data source when setting up a data query from SQL Server. In Advanced Editor, there are 2 possible setups:

  1.  

let

   Source = Sql.Database("Server", "DB1"),

   Query_Data = Source{[Schema=" Schema 1",Item="Tbl_ Schema 1_Data"]}[Data]

in

   Query_Data

 

and

  1.  

let

   Source = Sql.Database("Server "),

   DB1= Source{[Name=" DB1"]}[Data],

   Query_Data = ClinOps{[Schema=" Schema 1",Item=" Tbl_ Schema 1_Data "]}[Data]

in

   Query_Data

 

Both setups work exactly the same in power bi desktop i.e. no exceptions. However, the exception of IDbCommand interface will be thrown if there were more than one query and at least one of these queries used different setup to the rest of queries.

 

Solution

Open Advanced Editor to ensure all queries are setup using the same format.

 

How to open Advanced Editor:

Edit Queries --> select the query you want to modify --> Advanced Editor (small button next to Refresh Preview)

Helpful resources

Announcements
New Ranks and Rank Icons in 2020

New Ranks and Rank Icons in 2020

Read the announcement for more information!

New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

November 2019 Community Highlights

November 2019 Community Highlights

Get an overview of the events and great community content from November.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)