The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine
I have 3 sources, a folder with Excel files that are combined in Power Query, a separate Excel file and an Access database but they're Excel and Access files. All files have either *.xlsx or *.accdb. Both are Office 365 64bits. I created my Power Bi desktop file and works ok but when I publish it on a Sharepoint site, and I try refreshing the dataset, I get this error.
I've tried installing both versions of the Microsoft Access Database Engine 2010 and 2016 and still get the same error. If I try to publish the Access database as a list on the Sharepoint site, it would take a lot of time since it's updated daily and as of today, it has aproximately 500k registers. All the Excel files in the folder are deleted after 7 days and are replaced with new ones.