Forum Discussion

wfraser10's avatar
wfraser10
Regular Visitor
8 years ago

Unable to Schedule Data Refresh from Web Page

Hi,   I'm having a real issue getting the scheduled refresh of data to work in the PowerBI Report Server. Below is a brain dump of what I have done and what is not working.   I am harvesting data...
Anonymous's avatar
Anonymous
Not applicable
6 years ago

I am getting the same error. 

Has anyone found a solution for this?

I get the same error as the OP

Error returned: 'The credentials provided cannot be used for the Web source. (Source at <url removed>.). The exception was raised by the IDbCommand interface.

 

Detailed error log from "RSPowerBI_date_time.log" is below

 

 

2020-06-15 12:57:19.4940|INFO|51|Handling event with data: TimeEntered: 15/06/2020 2:57:09 AM, Type: Event, SessionId: 35774aee-7cb0-4446-b60a-260907fc572a, EventType: DataModelRefresh
2020-06-15 12:57:19.4940|INFO|51|Processing Data Model Refresh: SessionId: 35774aee-7cb0-4446-b60a-260907fc572a, Status: Starting Data Refresh.
2020-06-15 12:57:19.4940|INFO|51|Processing Data Model Refresh: SessionId: 35774aee-7cb0-4446-b60a-260907fc572a, Status: Starting Retrieving PBIX AsDatabaseInfo.
2020-06-15 12:57:19.5721|INFO|51|Processing Data Model Refresh: SessionId: 35774aee-7cb0-4446-b60a-260907fc572a, Status: Starting Verifying all the data sources are embedded.
2020-06-15 12:57:19.5721|INFO|51|Processing Data Model Refresh: SessionId: 35774aee-7cb0-4446-b60a-260907fc572a, Status: Starting Verifying connection strings are valid.
2020-06-15 12:57:19.5721|INFO|51|Processing Data Model Refresh: SessionId: 35774aee-7cb0-4446-b60a-260907fc572a, Status: Starting Streaming model to Analysis Server.
2020-06-15 12:57:19.6815|INFO|51|Processing Data Model Refresh: SessionId: 35774aee-7cb0-4446-b60a-260907fc572a, Status: Starting Refreshing the model.
2020-06-15 12:57:19.8533|ERROR|51|Error Processing Data Model Refresh: SessionId: 35774aee-7cb0-4446-b60a-260907fc572a, Status: Error Failed to refresh the model, Exception Microsoft.AnalysisServices.OperationException: Failed to save modifications to the server. Error returned: 'The credentials provided cannot be used for the Web source. (Source at <url removed>.). The exception was raised by the IDbCommand interface.
'.
   at Microsoft.AnalysisServices.Tabular.Model.SaveChangesImpl(SaveOptions options)
   at Microsoft.PowerBI.ReportServer.AsServer.TOMWrapper.RefreshModel(Database database)
   at Microsoft.PowerBI.ReportServer.AsServer.AnalysisServicesServer.RefreshDatabase(String databaseName, IEnumerable`1 dataSources, String clientSessionId)
   at Microsoft.PowerBI.ReportServer.WebHost.EventHandler.AnalysisServicesDataRefresh.RefreshDatabase(AsDatabaseInfo asDatabaseInfo)
   at Microsoft.PowerBI.ReportServer.WebHost.EventHandler.DataRefreshScope.<>c__DisplayClass34_0.<ExecuteActionWithLogging>b__0()
   at Microsoft.PowerBI.ReportServer.WebHost.EventHandler.DataRefreshScope.<ExecuteFuncWithLogging>d__33`1.MoveNext()
2020-06-15 12:57:19.8533|ERROR|51|Error Processing Data Model Refresh: SessionId: 35774aee-7cb0-4446-b60a-260907fc572a, Status: Error Failed Data Refresh, Exception Microsoft.AnalysisServices.OperationException: Failed to save modifications to the server. Error returned: 'The credentials provided cannot be used for the Web source. (Source at <url removed>). The exception was raised by the IDbCommand interface.
'.
   at Microsoft.PowerBI.ReportServer.WebHost.EventHandler.DataRefreshScope.ExecuteActionWithLogging(Action methodToExecute, String description, String localizedDescription, String messageInFailure, RefreshInfo refreshInfo, DataAccessors dataAccessors, ReportEventType operation, Boolean isDataRetrieval, Boolean showInExecutionLog, Boolean sendToTelemetry)
   at Microsoft.PowerBI.ReportServer.WebHost.EventHandler.AnalysisServicesDataRefresh.RefreshData(RefreshInfo refreshInfo)
   at Microsoft.PowerBI.ReportServer.WebHost.EventHandler.DataRefreshScope.<>c__DisplayClass34_0.<ExecuteActionWithLogging>b__0()
   at Microsoft.PowerBI.ReportServer.WebHost.EventHandler.DataRefreshScope.<ExecuteFuncWithLogging>d__33`1.MoveNext()