cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Veiga
Frequent Visitor

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

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.

 

😞

 

1 ACCEPTED SOLUTION
Veiga
Frequent Visitor

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.

;(

 

View solution in original post

3 REPLIES 3
Veiga
Frequent Visitor

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
Resident Rockstar
Resident Rockstar

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.

------------------------------------------------
1. How to get your question answered quickly - good questions get good answers!
2. Learning how to fish > being spoon-fed without active thinking.
3. Please accept as a solution posts that resolve your questions.
------------------------------------------------
More tips and guidance in my Power BI architecture and development blog
Veiga
Frequent Visitor

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!

Helpful resources

Announcements
August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 24 without aka link and time 768x460.jpg

Ted's Dev Camp - July 28, 2022

Watch Session 24 of Ted's Dev Camp along with past sessions!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors