Jul 26 2016 03:58 PM
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!