Are you opening the Excel file on the desktop to refresh it?


The trick I still haven't figured is being able to refresh the Excel file in Excel Services Online, connected to on-prem SQL, without opening the Excel file in the client application to get the data refresh.


For example refreshing from the Excel Web Part on a SharePoint page. A great SharePoint BI tool!


It works great if everything is on-prem or everything is in the cloud (Excel file on One Drive or SharePoint Online or SQL Azure).


It is Online to On-Prem just using Excel Services Online that is still getting me. Trying to accomplish without the Power BI Pro license too.


I greatly appreciate your time and the info you provided!