Forum Discussion
Direct Query for Excel Data
I know that various data sources support a Direct Query (https://docs.microsoft.com/en-us/power-bi/desktop-directquery-data-sources) but is it possible to connect an Excel spreadsheet held on a Share...
Yep, those are the only possibilities. I'd use refresh now to check out if it's working. Then you should set up some refresh times to refresh the report periodically everyday. I think there is no way to have automatic updates that refresh the report as soon as you change your file.
This is very recently now supported, in terms of the semantic model and data refresh from Sharepoint
Get data from Excel workbook files - Power BI | Microsoft Learn