I have multiple xlsx files on One Drive for Business and accessed these files using Get Data-> Sharepoint folder. Everything works fine on the desktop. But once I publish the file and try to refresh through the Power BI Online Service, i get the below error:
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 2010 Access Database Engine OLEDB provider is required to connect to read this type of file. To download the client software, visit the following site: https://go.microsoft.com/fwlink/?LinkID=285987.. The exception was raised by the IDataReader interface.
Any pointers appreciated.