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!

www.000webhost.com