Scheduled Refresh of XLS Source Files Once Deployed to Service

[Sohrab]

Hi,

I have an XLS file (97-2003 format, not xlsx) that is in a Sharepoint online folder.  In order to load this source into Power BI desktop, I had to first install the Access Database Engine on my computer.

After building a simple report with this dataset, I have published the report to the Power BI service.  I have enabled scheduled refresh for this dataset.  After manually triggering the refresh on this dataset in the service, I get an error: 

Message: 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 2010 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.

How can I refresh my dataset without changing the input file format?

For reference, this is my query that loads the file:

let
Source = SharePoint.Files("https://MYSITE.sharepoint.com/sites/PowerBI/", [ApiVersion = 15]),
#"Profit_and_Loss_Detail" = Source{[Name="Profit_and_Loss_Detail__Power_BI.xls",#"Folder Path"="https://MYSITE.sharepoint.com/sites/PowerBI/Shared Documents/General/"]}[Content],
#"Imported Excel" = Excel.Workbook(#"Profit_and_Loss_Detail__Power_BI xls_https://MYSITE sharepoint com/sites/PowerBI/Shared Documents/General/"),
#"Profit and Loss Detail - Power " = #"Imported Excel"{[Name="Profit and Loss Detail - Power "]}[Data],
#"Kept First Rows" = Table.FirstN(#"Profit and Loss Detail - Power ",1),
#"Removed Other Columns" = Table.SelectColumns(#"Kept First Rows",{"Column1"}),
#"Renamed Columns" = Table.RenameColumns(#"Removed Other Columns",{{"Column1", "Name"}})
in
#"Renamed Columns"

Thanks to @TomMartens for suggesting I post this question here.

[v-eachen-msft]

Hi @Sohrab ,

According to the error message, the provider hasn't been registered on the machine on which the application is running. The ACE provider is not installed on Windows operating systems by default. You have to install it.

Here are blogs could be your reference:

https://www.mikesdotnetting.com/article/280/solved-the-microsoft-ace-oledb-12-0-provider-is-not-regi...

https://www.connectionstrings.com/the-microsoft-ace-oledb-12-0-provider-is-not-registered-on-the-loc...

[Sohrab]

Hi,

Thanks for your response.  Please note that I am not running this on my computer.

I have published the PBIX file to the Power BI Service.  I am trying to refresh the source data that is in XLS format to work in the service.

Please let me know what steps I need to complete in order to get this working.

P.S. - this is the same issue that was reported by another user that appears to be unresolved: https://community.powerbi.com/t5/Service/XLS-file-refresh/td-p/695407

Thanks,

Sohrab