cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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.

12 REPLIES 12
Highlighted
Resolver IV
Resolver IV

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
Helper II
Helper II

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

Highlighted
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.

Highlighted
Regular Visitor

Re: SCHEDULED REFRESH ERROR

Datasource connectionstrings in PBRS are case sensative. 

 

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

 

 

Highlighted
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.

Highlighted
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

Highlighted
New Member

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)

Highlighted
Frequent Visitor

Re: SCHEDULED REFRESH ERROR

Mine are both defined the same way but still throw the error. 

 

Just for fun, I deleted the report from the pbrs server, then saved it back up there.  The Data Source 1 had no credentials saved so I set that up, but I cannot access Data Source 2 for the second query.  I assume this is the cause of the error. Even though both are set up correctly with the credentials in the desktop, it seems they are wiped out upon deploying/publishing the report to the server.  

 

Both data sources use the same database service account and connect to the same database.  The queries are sql queries, not full table imports, if that has anything to do with it.

Any other ideas?  

Highlighted
Regular Visitor

Re: SCHEDULED REFRESH ERROR

Hi,

 

Have any passwords recently expired and or changed?

 

 

Helpful resources

Announcements
Super Users of the Quarter - Q2 2020

Super Users of the Quarter - Q2 2020

Who are our Super User Superstars? Who made it to the top of the leaderboards? Get the answers!

June 2020 Community Highlights

June 2020 Community Highlights

Featured community members, changes to the Community, and more! Read up on recent Power BI community news.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021