Access Database connection causing Unspecified error in scheduled refresh

Anonymous — Tue, 28 Jan 2020 14:03:38 GMT

Hello all,

I have a dashboard that was working fine on Desktop and on the Server until I connected an Access database to it. Now, it still refreshes just fine on desktop, but I get this error now during the scheduled refresh on the server:

Unspecified error. The exception was raised by the IDbCommand interface.

Here is what the connection looks like in Advanced Editor on Desktop (I just pasted the Source lines and ommitted the rest):

let Source = Access.Database(File.Contents("\\X\Y\Z\YoY.accdb"), [CreateNavigationProperties=true]), _tblYoY = Source{[Schema="",Item="tblYoY"]}[Data],

And I here is the Connection message on the server showing the credentials are working:

Does anyone understand what's going on here?

topic Access Database connection causing Unspecified error in scheduled refresh in Report Server

Access Database connection causing Unspecified error in scheduled refresh