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.
Greetings community,
I published a dashboard using the live data from the database and web data(Excel workbook in share point). While I tried to refresh the entire data in the powerBI Desktop, it worked well. But when I tried to schedule an auto-refresh, it failed. I manually tried to refresh the dataset in the powerBI website but I am getting this error:
Data source error: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"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 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."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult...}}} Table: Excel-Web-Book.
Cluster URI: WABI-US-NORTH-CENTRAL-E-PRIMARY-redirect.analysis.windows.net
Activity ID: 8764c394-e163-42a0-8bce-b5b906045ead
Request ID: ea168954-48f6-f2fd-97ac-20ab6517c3d1
Time: 2020-12-02 15:06:47Z
Here the Excel-Web-Book is an excel workbook taken from the share point. I understood that this error is from the excel workbook but I am not understanding why this issue arose. Can anyone help me how to solve this error?
Many thanks in advance
@amitchandak @Fowmy
Hi @Anonymous ,
Sorry to disturb you...
But did I answer your question ? Please mark my reply as solution. Thank you very much.
Best Regards,
Stephen Tao
Hi @Anonymous ,
The error shows that you should intall AccessDatabaseEngine_X64 on your machine. Please try to complete it.
Reference: https://community.powerbi.com/t5/Desktop/How-to-Resolve-this/td-p/145205
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.