I have an issue that I am struggling to resolve. I haven't used PowerBI in several months so was a little rusty. My data is coming from an Access Database saved in a SharePoint location. I was asked to make an update to the report and opened the desktop app, made the updated, brought in another query from the database saved and published the report. Here's the issue, in my "rustiness" I incorrectly brought the query into the report. Instead of selecting "SharePoint Folder" in the Get Data screen, I selected "Access Database". I didn't realize this until after I published the changes. I went into the desktop app and corrected the source and republished, but the Schedule Refresh in powerbi.com keeps failing and I cannot figure out how to resolve the issue. I am getting the following error:
Data source error: DataSource.NotFound: <ccon>Microsoft Access: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. The 64-bit version of the Access Database Engine OLEDB provider may be required to read this type of file. To download the client software, visit the following site: https://go.microsoft.com/fwlink/?LinkID=285987.. </ccon>. The exception was raised by the IDbCommand interface. Table: Front L2.
Cluster URI: WABI-WEST-US-redirect.analysis.windows.net
Activity ID: c5316991-5870-4494-932f-1ed5b751496d
Request ID: 39cff0cd-01ba-4b1c-a9de-25745a44283b
Time: 2023-01-16 09:39:05Z
I do have the "64-bit version of the Access Database Engine OLEDB " installed on my computer. The Table referenced in the error changes every time I try to update. Am I best to delete all and start fresh?
