Our team wants to set up auto-refresh for a PBI dashboard with data from Access databases, SQL databases, and Excel. For Access databases and Excel worksheets, we changed the data sources to web links like:
When we set up auto-refresh, we got the following 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 this type of file. To download the client software, visit the following site: https://go.microsoft.com/fwlink/?LinkID=285987.
I've installed the Access Database Engine, checked everything we're using are 64 bit, and kept Excel files as XLSX files based on the instructions, but are still getting the same error message.
Does anyone know what might be the solution to this issue?