Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Have you faced this issue like this when it works in Power BI Desktop and not work in Power BI Service when you connect to the excel file from SharePoint?
Best Regards,
Community Support Team _ Yingjie Li