Forum Discussion

coolleks's avatar
coolleks
Regular Visitor
8 years ago

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!

Report Server On premises

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago
    hello everybody we have the same issue rigth now "Credentials are required to connect to the AnalysisServices source" ny news? thanks in advance
    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

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

  • sayaliredij's avatar
    sayaliredij
    Solution Sage
    5 years ago

    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

  • pratafran's avatar
    pratafran
    Helper III
    5 years ago

    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?