Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Good day!
We have a series of programmed Power BI files in on-premise Power BI Report Server. These reports obtain information from SSAS cubes in ImportData connection mode. The same report can run successfully or with errors within minutes (from 14 executions last night of 7 different reports, 4 failed and 10 were successful).
The errors we're having are:
{"SessionID":"15aba707-298d-4dcf-9f97-a0fd30d0168c","Errors":[{"ErrorCode":-1055784932,"Message":"AnalysisServices: Server: The operation was cancelled because of locking conflicts.. The exception was raised by the IDbCommand interface.","CallStack":null},{"ErrorCode":-1055784932,"Message":"The command has been canceled.. The exception was raised by the IDbCommand interface.","CallStack":null}]}
{"SessionID":"6a57b0cd-6411-411a-8cfc-abb000c36654","Errors":[{"ErrorCode":-1055784932,"Message":"AnalysisServices: Server: The operation was cancelled because of locking conflicts.. The exception was raised by the IDbCommand interface.","CallStack":null},{"ErrorCode":-1055784932,"Message":"The command has been canceled.. The exception was raised by the IDbCommand interface.","CallStack":null},{"ErrorCode":-1055784932,"Message":"The command has been canceled.. The exception was raised by the IDbCommand interface.","CallStack":null},{"ErrorCode":-1055784932,"Message":"The command has been canceled.. The exception was raised by the IDbCommand interface.","CallStack":null},{"ErrorCode":-1055784932,"Message":"The command has been canceled.. The exception was raised by the IDbCommand interface.","CallStack":null},{"ErrorCode":-1055784932,"Message":"The command has been canceled.. The exception was raised by the IDbCommand interface.","CallStack":null},{"ErrorCode":-1055784932,"Message":"The command has been canceled.. The exception was raised by the IDbCommand interface.","CallStack":null},{"ErrorCode":-1055784932,"Message":"The command has been canceled.. The exception was raised by the IDbCommand interface.","CallStack":null},{"ErrorCode":-1055784932,"Message":"The command has been canceled.. The exception was raised by the IDbCommand interface.","CallStack":null}]}
{"SessionID":"c3e2fcea-67cf-4764-838f-75929ccc6d0a","Errors":[{"ErrorCode":-1055784932,"Message":"AnalysisServices: Server: The operation was cancelled because of locking conflicts.. The exception was raised by the IDbCommand interface.","CallStack":null},{"ErrorCode":-1055784932,"Message":"The command has been canceled.. The exception was raised by the IDbCommand interface.","CallStack":null},{"ErrorCode":-1055784932,"Message":"The command has been canceled.. The exception was raised by the IDbCommand interface.","CallStack":null}]}
{"SessionID":"05be2e40-cfde-4451-8615-c69472389e94","Errors":[{"ErrorCode":-1055784934,"Message":"AnalysisServices: Server: The operation was cancelled because of locking conflicts.. The exception was raised by the IDataReader interface.","CallStack":null}]}
We found information about the first error code ("1055784932"), that corresponded to several connections in one file with different case-sensitive names. We corrected this error and now the file is refreshing correctly most of the time (previously always failed).
We haven't found any information about the second error code ("1055784934").
A couple of Power BI refresh processes executed at the same time that the some dimensions and cubes were processing. However, the processed cubes are not used in the report (maybe some common dimensions).
Is there any error code guide we can refer to? Is it necessary to raise a ticket with Microsoft? Has anyone seen these errors before?
Regards!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
7 | |
3 | |
3 | |
2 |
User | Count |
---|---|
15 | |
11 | |
5 | |
5 | |
2 |