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!
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?
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
I am also having the issue. Could someone look into it?