cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Resolver I
Resolver I

SharePoint Refresh - Failure

Hi, i have an report which data source is share point. Since last Friday the dataset is not able of refrashing. (In both cases at service and at desktop). I have an error message attached. Can somebody assist me to resolve this problem?

Something went wrong
There was an error when processing the data in the dataset.
Please try again later or contact support. If you contact support, please provide these details.
Message: 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. Table: LoadBynetProcumentExcels.
Cluster URI: WABI-WEST-EUROPE-redirect.analysis.windows.net
Activity ID: aeebad07-87e8-4845-b9fc-9b58b5b4d4e7
Request ID: ce1cfda5-7c68-46af-b9c6-086f4caabeeb
Time: 2019-05-15 04:14:05Z

2 REPLIES 2
Highlighted
Frequent Visitor

Re: SharePoint Refresh - Failure

Hello,

At least the version desktop you will need to download the Acess DataBase 64 bits.

https://www.microsoft.com/en-us/download/details.aspx?id=13255

image.png

I have currently the same problem trying to refresh the data from the service. When I found out how to solve it I will let you know. 

Highlighted
Frequent Visitor

Re: SharePoint Refresh - Failure

Hello Ritaf,

I share with you this thread, about the problem in Service: https://community.powerbi.com/t5/Service/Power-BI-online-refresh-Microsoft-ACE-OLEDB-12-0-error/m-p/...

Currently the unique solution is to convert your source files in the format you are working, 64 bits or 32 bits. ( if they are .xls to .xlxs etc)

Regards

Helpful resources

Announcements
Super Users of the Quarter - Q2 2020

Super Users of the Quarter - Q2 2020

Who are our Super User Superstars? Who made it to the top of the leaderboards? Get the answers!

June 2020 Community Highlights

June 2020 Community Highlights

Featured community members, changes to the Community, and more! Read up on recent Power BI community news.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Kudoed Authors