I have been able to use Excel as a datasource (locally or via sharepoint). I just started to try using Acces as a data source instead. I have 32bit applications on my server (Office/PowerBI Desktop). I can get data from Access locally or in sharepoint. I create my report and publish it no problem. But when I go to refresh my dataset I get the message below. I installed the 32bit 2010 Access DB Engine same issue. I went over to another server and installed the 64bit version of PowerBI. This time I instllead the 64bit version of 2010 Access DB Engine. Same issue! Again my Access is an .accdb file created in a 32bit application. I have tried accessing my db local and via sharepoint and get the same result. Any ideas?
Underlying error code: -2147467259
Underlying error message: 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 2010 Access Database Engine OLEDB provider may be required to read 'msflabor.accdb'. To download the client software, visit the following site: https://go.microsoft.com/fwlink/?LinkID=285987.
DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259
Microsoft.Data.Mashup.ValueError.Reason: DataSource.NotFound
Cluster URI: WABI-US-EAST2-B-PRIMARY-redirect.analysis.windows.net
Activity ID: 3f419d59-3dd4-4bec-af21-92fc0df2a197
Request ID: 02f690b3-7936-bb92-3f7f-fcbd17361595
Time: 2020-12-08 22:33:46Z
