I got the below error message when PowerBI service refreshes dataset. The file is located on Sharepoint. I followed instructions installing the 64-bit version of the Access Database Engine but it still doesn't work.
Data source error: DataSource.NotFound: <pii>Excel Workbook: 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.</pii>. . The exception was raised by the IDbCommand interface. Table: ChASE WW NDP. Cluster URI: WABI-US-NORTH-CENTRAL-C-PRIMARY-redirect.analysis.windows.net Activity ID: 2bfb97ca-2aa8-4f9f-b6af-56ed5a3f57cf Request ID: c480b954-f9f9-4b6e-99bf-26520323a230 Time: 2021-12-03 05:42:29Z