Forum Discussion

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

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

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.