Issues with refreshing data sets based on SharePoint file

[AvdSchilden]

I have a report with an Excel file located on SharePoint as source. I am able to refresh the data set in Power BI desktop, but once I am trying to refresh it manually on powerbi.com I get an error;

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 is required to connect to read this type of file

I have installed this provider in 64-bit, and my Office and Power BI desktop are both 64-bit as well.

I am using organizational authentication.

Does any hve experience with this issues or have some good advice regarding the usage of SharePoint files as source?

Thanks in advance!

[Anonymous]

Hi @AvdSchilden,

Do you connect to .xls Excel file and refresh it in Power BI Service? If that is the case, refreshing against a .xls file is not supported. As stated in this article, Power BI supports importing or connecting to workbooks created in Excel 2007 and later. Workbooks must be saved as .xlsx or .xlsm file type and be under 1GB.

To work around the above issue,  you can change Excel file form type .xls to .xlsx, then you are able to refresh the dataset in Power BI Service.

Thanks,
Lydia Zhang