Forum Discussion
Refresh local Excel Datasource in PowerBI Desktop
I am using many excel files as a datasource for my PowerBI report in PowerBI desktop. Is there any way I can refresh the excel files data source once a day ? I've checked, In Power BI Desktop we can...
You can schedule refreshes in the Power BI Service but not in Power BI Desktop (which is designed for report creation rather than report consumption). Note that you'll need to have a Data Gateway in order for the Service to connect to your Excel files (unless you have the Excel files saved to OneDrive or SharePoint or another online source).
DirectQuery is not compatible with Excel files since DirectQuery requires the source to essentially be a server that runs its own queries.