Access DB Dataset Refresh error Microsoft.ACE.OLEDB.12.0
I have a report built in PBI Desktop using an Access DB on Sharepoint as a source (using the Sharepoint folder Connector). I can work with the file in desktop no problem and refresh at will. When I publish the report to service, I get an error regarding the Access OLEDB provider.
I have the Access Database Engine installed on my local machine and, as mentioned, I can refresh in desktop no problem. I can also pull a local copy of the Access DB and open/edit it. This only seems to be impacting when published to service. This worked fine for the first few days after it was published and only staretd erring at the end of August. I see many mentions of this error in relation to having a .xls Excel source, but nothing around AccessDB as a source. I've gone through this article as well to no avail.
Has anyone else seen this and were you able to fix it? For now, whenever teh data is refreshed I have to open in Desktop, refresh, publish. Would much prefer to let the data set refresh daily within service