Forum Discussion
Issues with refreshing data sets based on SharePoint file
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; ...
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