Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Automatic refresh .xls files from Sharepoint folder in Desktop and Power BI Server

Hi Team, 

 

The query is related to the refresh in Power BI service. When i am trying to trigger the manual refresh in Power BI Services, it is throwing the error (OLEDB error). The data set for the report is .xls files which is residing in Sharepoint folder. 

The same thing worked, if i change the file extension of the file from .xls to .xlsx.

Any quick help is highly appreciated.

 

Regrds, 

Arushi

 

General Comment
Interesting Links
Show and Tell

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Anonymous I didn't think that .xls files were really supported in SharePoint Online, at least not for things like viewing the files online.

  • v-diye-msft's avatar
    v-diye-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Anonymous 

     

    If you want to make hourly refresh work after making changes to xlsx files, please directly connect to the xlsx stored on SharePoint Online folder from Power BI Service rather from Power BI Desktop.

    However, when you connect to xlsx files from Power BI Desktop, you would need to store the PBIX file in SharePoint online, then connect to the PBIX file via "Get Data->Files->SharePoint Team Sites" entry in order for automatic refresh to work. In this case, when you add new measures, change column names, or edit visualizations in Power BI Desktop file, once you save, those changes will be updated in Power BI , usually within about an hour. When you make changes in the xlsx file, you can only manually refresh the dataset by using Refresh now or set up a refresh schedule by using Schedule Refresh. For more details, please review this article.