Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Error 'Microsoft.ACE.OLEDB.12.0 on OneDrive

Hi all! Hope you all are fine   I'm trying to schedule update a dataset, but everytime it gives me this issue:   "Excel Workbook: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the ...
Need Help
  • nandukrishnavs's avatar
    nandukrishnavs
    5 years ago

    Anonymous  Both gateway and access database engine on same machine and still you are facing the issue, then please raise a support ticket.

nandukrishnavs's avatar
nandukrishnavs
Community Champion
5 years ago

Anonymous  If possible, save your excel file in OneDrive and copy the path from the browser.

Example : https://people.xxxxxxx.com/personal/xxxxxxxxxxxx/Documents/Best%20Practices/Financial%20Sample.xlsx

Then use the Web connector in the Power BI desktop. You can use the previously copied path in connection. So, you can avoid gateway dependency and you will be able to configure the schedule refresh. 




Regards,
Nandu Krishna

Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 👍

Proud to be a Super User!

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

nandukrishnavs,

I've made two files, each one conneceted differently. the one I'd send you used the local file, but the folder is on the client's OneDrive (I synched the folder), and the othe is directly to the web path. Both return the same error.

Also, gateway is already configured and paths are shown, but still no sucess.