Erro : Microsoft.ACE.OLEDB.12.0 only POWER BI SERVICE (ONLINE)

[Veiga]

Guys, I searched a lot and didn't find an answer.

Does Power BI Service support XLS update on Shorepoint?

On the desktop everything is ok.

The Microsoft did not implement Access drivers cloud based service?

Erro: 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 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.

This error in refresh  Power BI Service.

😞

[Veiga · Accepted solution]

Solved

Using Excel Files with Power BI Desktop and SharePoint – The White Pages (tygraph.com)

There is no solution.

Simply PB Service and Sharepoint do not accept XLS.

Finish.

;(

[otravers]

You should avoid loading xls files in Power BI, they can be read incorrectly because of formatting:

https://www.ehansalytics.com/blog/2020/2/15/avoid-using-excel-xls-files-as-data-source

If you have too many files to save them as xlsx manually, you might want to look into Power Automate Desktop to assist with that.

[Veiga]

On the desktop everything is working.

Xls comes via email attachment and is saved to Sharepoint.

From what I'm researching it's not possible to do a dataset automation with xls files, via sharepoint or ondrive.

Via PowerAutomate, only via Third Party UI or API.

We have the difficulty and we sell you the ease.

Very sad, that.

TKS!