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 from a webapp html page that depends on url parameters. The credentials in the Data Sources tab work fine and are marked as Connected Successfully but when the scheduled refresh runs it errors complain gthat the credentials provided cannot be used.

 

[0] -1055784932: The credentials provided cannot be used for the Web source. (Source at <App Url>.). The exception was raised by the IDbCommand interface.

Additionally I have noticed that the Data Sources tab does not show the complete URL including paramters ni the Connection String box...

 

Can anyone guide me on how to get this web page Data Source to work?

 

Warm Regards,

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi,

     

    Do you find a solution for this issue?

  • 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()