Hello to all,
we are facing what we presume to be an unexpected behaviour from the the power bi report server when scheduling a refresh of an access database. with the execution account and the subscription account assigned to a domain user we have unexpected error during the refresh (a generic The command has been canceled.. The exception was raised by the IDbCommand interface with no further details on the log).
the access to the file is performed as the NT AUTHORITY\NETWORK SERVICE (confirmed in ExecutionLog3 table).
even with the logging set to 4 we get nothing meaningful on the RSPowerBI log:
at Microsoft.AnalysisServices.AdomdClient.AdomdCommand.ExecuteXmlReader()
at Microsoft.PowerBI.ReportServer.AsServer.AnalysisServicesXEventLogger.TryCreatingAndSubscribingToXEventsTrace()
2019-12-12 13:09:32.8564|INFO|11|Attempting to connect to Analysis Services XEvent logging...
2019-12-12 13:09:33.0595|ERROR|11|Error creating Analysis Services XEvent traceMicrosoft.AnalysisServices.AdomdClient.AdomdErrorResponseException: Failed to complete the command. XEvent is not initialized.
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.IExecuteProvider.Execute(ICommandContentProvider contentProvider, AdomdPropertyCollection commandProperties, IDataParameterCollection parameters)
at Microsoft.AnalysisServices.AdomdClient.AdomdCommand.ExecuteXmlReader()
at Microsoft.PowerBI.ReportServer.AsServer.AnalysisServicesXEventLogger.TryCreatingAndSubscribingToXEventsTrace()
2019-12-12 13:09:33.0908|ERROR|11|An error occured reading Analysis Services Xevent: Microsoft.AnalysisServices.AdomdClient.AdomdErrorResponseException ErrorCode:-1055653884
Message:Either the trace with the ID of 'PBIRSTrace' does not exist in the server with the ID of '[edited]\PBIRS', or the user does not have permissions to access the object.
2019-12-12 13:09:35.1064|INFO|10|Attempting to connect to Analysis Services XEvent logging...
2019-12-12 13:09:35.1064|ERROR|10|Error creating Analysis Services XEvent traceMicrosoft.AnalysisServices.AdomdClient.AdomdErrorResponseException: Failed to complete the command. XEvent is not initialized.
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.IExecuteProvider.Execute(ICommandContentProvider contentProvider, AdomdPropertyCollection commandProperties, IDataParameterCollection parameters)
at Microsoft.AnalysisServices.AdomdClient.AdomdCommand.ExecuteXmlReader()
at Microsoft.PowerBI.ReportServer.AsServer.AnalysisServicesXEventLogger.TryCreatingAndSubscribingToXEventsTrace()
2019-12-12 13:09:35.6846|ERROR|4|Error Processing Data Model Refresh: SessionId: f4ddca88-de88-4ad8-9dee-060b177a31a2, Status: Error Failed to refresh the model, Exception Microsoft.AnalysisServices.OperationException: Failed to save modifications to the server. Error returned: 'Unspecified error. The exception was raised by the IDbCommand interface.
If we change the service account to the to the identity of the domain and set the authentication for the datasource the refresh works fine.
Are we wrong or the execution and subscription account should be sufficient to make the refresh working?
thanks
andrea
