topic Re: Error when Refreshing SQL Data in Report Server

Error when Refreshing SQL Data

jmiridium — Tue, 05 Dec 2017 21:34:22 GMT

Getting the following error:

SessionID: 7f671cd2-63b8-4c82-9b09-61b6f6269a18
[0] -1055784932: Credentials are required to connect to the SQL source. (Source at entsql01;master.). The exception was raised by the IDbCommand interface.
[1] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface.
[2] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface.
[3] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface.
[4] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface.
[5] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface.
[6] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface.
[7] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface.


I verified credentials and everything works. What is the issue?

Re: Error when Refreshing SQL Data

jmiridium — Tue, 05 Dec 2017 21:36:35 GMT

What's really funny is I can use the same credentials on a different report and it refreshes just fine

Re: Error when Refreshing SQL Data

jmiridium — Wed, 06 Dec 2017 14:34:14 GMT

Bump

Re: Error when Refreshing SQL Data

BrookBracewell — Mon, 19 Mar 2018 14:07:18 GMT

Did you work out what was going on with this? I am using Power BI Server- and the report will not refresh via the scheduled refresh screen with the same meesage you got.

Re: Error when Refreshing SQL Data

Anonymous — Wed, 21 Mar 2018 14:51:19 GMT

I have exactly the same issue. Same credentials across four different dashboards, works on 3 and fails on the 4th with the same error that you've dsiplayed. No idea why.

Re: Error when Refreshing SQL Data

niallhannon — Thu, 22 Mar 2018 10:05:26 GMT

Same issue here. Did you all use a clean reportserver database when installing PBIRS or did you upgrade an existing RS database from a standard SSRS installation?

Re: Error when Refreshing SQL Data

BrookBracewell — Thu, 22 Mar 2018 10:14:16 GMT

It was a brand new installation. I am looking currently at 2 reports built last week. both with multiple datasources to connect to, both getting test connection success, but one failing due to apparently one set of credentials against jsut one of the reports

Is this grouped moniored by any techies at Microsoft- of is there an official route to raising the issue? (it's killing me)

Re: Error when Refreshing SQL Data

niallhannon — Thu, 22 Mar 2018 10:37:12 GMT

I have a support ticket in with MS about this and they are looking at the issue. I sent them a link to this thread and the engineer said they are going to as the Product Group about it.

I just sent it in via Power BI, can everyone not just log tickets to MS too?

Re: Error when Refreshing SQL Data

niallhannon — Thu, 22 Mar 2018 10:38:03 GMT

https://powerbi.microsoft.com/en-us/support/

Re: Error when Refreshing SQL Data

Anonymous — Fri, 23 Mar 2018 12:48:31 GMT

Is there any update on this?

Re: Error when Refreshing SQL Data

mgmeyer — Fri, 23 Mar 2018 23:14:36 GMT

After you published the report did you update the credentials in DataSource management page?

Re: Error when Refreshing SQL Data

niallhannon — Mon, 26 Mar 2018 07:10:52 GMT

Yeah. tried that but still not working.

Re: Error when Refreshing SQL Data

Anonymous — Mon, 26 Mar 2018 08:38:13 GMT

Same here. Tried again this morning, uploaded the report using the March 2018 Desktop build. Set the data source, tesed the connection successfully, set a refresh schedule and it still failed.

We need a fix on this ASAP!!!

Re: Error when Refreshing SQL Data

mgmeyer — Mon, 26 Mar 2018 18:52:13 GMT

@Anonymous or @niallhannon can either of you private message me a simple report that can repro the issue? Also in the cases were your getting the issue are there multiple DataSources on the report? If so are they all SQL or is it a mix? Thx!

Re: Error when Refreshing SQL Data

niallhannon — Tue, 27 Mar 2018 07:03:20 GMT

Hi @mgmeyer, I have a ticket submitted via Power BI Pro support, ticket ID is 118032691186025

So I am going to follow up that way and will update here if I get updates.

But yes, there would be multople data sets but all coming from the one SQL server source\database on-premise.

Re: Error when Refreshing SQL Data

Anonymous — Tue, 27 Mar 2018 07:19:53 GMT

Same here. I have a ticket submitted also.

I can't reproduce the error in any other report at all and the current report isn't something I am able to distribute.

The data is coming from 10 views on an SQL Server and I'm pulling them in by executing a stored procedure in the data source SQL statement. We've used this format in other reports and it works fine.

Re: Error when Refreshing SQL Data

BrookBracewell — Tue, 27 Mar 2018 08:22:35 GMT

I can't reproduce- that is kind of the problem. I have one report wikth 4 data sources working correctly, and another with 3 (of the same sources) that fails. I can't see how to reproduce the problem unfortunately.

Re: Error when Refreshing SQL Data

Anonymous — Tue, 27 Mar 2018 13:27:08 GMT

We seem to have encountered this issue as well.

We have a dataset with a couple of SQL queries onto a SQL DB backend. one query is very simple, the other is a bit of a nightmare as it's doing lots of string manipulation and CASE statements.

I've tried onto other SQL DB's using just tables. Works Fine though runs out of memory now and agian.

I've tried onto other SQL DB's using views (simulating stored queries?). Works fine (used a smaller dataset this time so no memory issues)

Repeated the import of several views from the same version of SQL Server (noticed it was 2008R2 in the report that isn't working) that seems fine.

Am now isolating out different permissions at each end to see if that's somehow related. I haven't got admin access at the far end to run profiler to see the queries as they are arriving alas.

Re: Error when Refreshing SQL Data

Anonymous — Tue, 27 Mar 2018 15:05:08 GMT

Well, I've stripped back the entire dashboard and loaded one view at a time. I've reached the point where I have two views from one SQL Server database and a third from a different database.

The data source option asks quite correctly for 2 authentications to access the data, I enter both, test connections successfully and set the scheduled refresh.

The refresh fails stating the credentials are incorrect. When I check the data sources and test the connections, one fails, so I set the password, test both again successfully, set a new refresh and ....yet, you've guessed it, it fails on exactly the same issue.

I'm just going around in a circle.

Microsoft.....any advice?

Re: Error when Refreshing SQL Data

niallhannon — Tue, 27 Mar 2018 15:06:34 GMT

I think the issue might be caused by having more than one of the same data source in the PBIX file where the only difference is a uppercase letter

e.g. I have have two datasources

server1; database1

server1; Database1

I can replicate the issue doing that, can anyone confirm?