cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
coolleks
Regular Visitor

PBIRS schedule refresh fails

I created the power BI report using import model and publishee to PBIRS. The report runs fine manually. But schedule refresh fails.

 

 

SessionID: e004aceb-c4cb-4aff-b89c-84545b4a3117 [0] -1055784932: Credentials are required to connect to the AnalysisServices source. 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.

 

It has two data sources 1. Analysis services and 2. Excel file (which is placed on the shared network)

 I am using windows credentials to connect to both the data sources. and connected successfully and when run manually data is populated.

 

Thanks in Advance!

4 REPLIES 4
pratafran
Helper III
Helper III

I'm having the same problem. Credentails are entered and validated ok in "Data sources" but the scheduled refresh continue failing with the same error message. It refreshed ok on manual.

Any solution?

sayaliredij
Solution Supplier
Solution Supplier

I am also getting same error. Report gets refreshed on normal PBIX file without any problem. But once published on service, it fails due to error "Credentials are required to connect to the AnalysisServices source. "

We are updating credentials at dataset settings. but still it fails

Anonymous
Not applicable

hello everybody we have the same issue rigth now "Credentials are required to connect to the AnalysisServices source" ny news? thanks in advance

I am also having the issue. Could someone look into it?

Helpful resources

Announcements
Join Arun Ulag at MPPC23

Join Arun Ulag at MPPC23

Get a sneak peek into this year's Power Platform Conference Keynote.

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!