Scheduled Refresh + OneDrive

[Desenv2sti]

Hi guys!

I'm facing an issue related to the Auto Refresh.

I currently use a .XLSX as database, directly from my OneDrive account. During the development, everything works. When I upload the .pbix to service, it keeps returning errors though.

This is the error:

cel 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.

It seems that the Dashboard actually refreshes, but the error still remains and the real problem is that after X times, the Auto refresh gets disabled automatically.

I was told PBI can't work with .XLS properly, so I changed the file extension to .XLXS, but the problem seems to be the same.

Does anybody know how to solve it?

Thanks.

[Anonymous]

Hi @Desenv2sti ,

Have you tried the solutions in the link given below the error message?

Best Regards,

Jay

[ibarrau]

Hi. Can you show us how you are connecting to the file? something like your PowerQuery source in the Transform data tool.

I know a guide that haven't failed before if you want to try it:
https://blog.ladataweb.com.ar/post/185337134590/alternativa-para-conectar-power-bi-a-onedrive

Regards,

[Desenv2sti]

Hey @ibarrau !!

Thank you for your answer, but this is exactly the way it is 😞

The data updates, but the error remains. After 3, 4 or 5 (I don't know) times, it just stops.

What could it be?

[ibarrau]

Hi. I'm asking for the power query code to understand the connection and guide you to connect directly to the web without gateway. This is usually an error of a data gateway. Commonly through from access or xls files with different versions between PBI Desktop/Gateway and Office tools. When one is 32 bits and the other is 64bits, they usually send a conflict.

My idea was connecting like the post I have sent to avoid that version issue.

I hope that make sense