cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
jmiridium Member
Member

Error when Refreshing SQL Data

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?
29 REPLIES 29
jmiridium Member
Member

Re: Error when Refreshing SQL Data

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

jmiridium Member
Member

Re: Error when Refreshing SQL Data

Bump

BrookBracewell Frequent Visitor
Frequent Visitor

Re: Error when Refreshing SQL Data

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.

SWOS Regular Visitor
Regular Visitor

Re: Error when Refreshing SQL Data

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.

niallhannon Regular Visitor
Regular Visitor

Re: Error when Refreshing SQL Data

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?

BrookBracewell Frequent Visitor
Frequent Visitor

Re: Error when Refreshing SQL Data

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)

niallhannon Regular Visitor
Regular Visitor

Re: Error when Refreshing SQL Data

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?

niallhannon Regular Visitor
Regular Visitor

Re: Error when Refreshing SQL Data

SWOS Regular Visitor
Regular Visitor

Re: Error when Refreshing SQL Data

Is there any update on this?

Helpful resources

Announcements
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 175 members 1,853 guests
Please welcome our newest community members: