Scheduled refresh issue with pbix report that connects to Access DB data source in PBIRS

This article discusses about the error “The login failed for data source ‘Unknown’ that occurs with scheduled refresh of pbix report that uses Access database as the data source and the solution to get the refresh to work.


Error message: Data source error: The login failed for data source ‘Unknown’



Clicking on    in the status, would give you details of the error:



Error details:

SessionID: f94a2716-08e8-47a3-87e8-668c92d4cae2
[0] -1055784932: DataFormat.Error: Unspecified error. ADB.accdb. ;Unspecified error. The exception was raised by the IDbCommand interface.


Though the test connection to data source succeeds, the refresh fails