Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Power BI Report Server - Sharepoint Datasource scheduled refresh

Hi,   We have a power BI dashboard that connects to a sharepoint document. I have used the Sharepoint Folder datasource to connect to this document. It works well on the power BI report server desk...
SharePoint
Web
d_gosbell's avatar
d_gosbell
Icon for Super User rankSuper User
7 years ago

What is the error you are getting? Is it just one about incorrect username/password?

 

Have you tried entering the username in the form of <domain>\<username> ?

Anonymous's avatar
Anonymous
Not applicable
6 years ago

We are also getting authentication errors when PBIRS is trying to refresh data from a SharePoint 2010 (on prem) URL.  Strangely, when credentials are saved in PBIRS and clicked "Test connection", we get a successful result, however, scheduled refreshing fails.

Has anyone found a solution to this?

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