Forum Discussion
Excel Services and On-Premises SQL Data
If you're talking about Excel Online in Office 365 connecting to on prem data, that is possible with the Gateway if you're using PowerPivot. You can use Power BI to schedule an Excel Workbook refresh from on premises data.
If you're talking about on prem Excel Services or Excel Online, you can configure the data connection to refresh on open.
John White Does it allow user to do the on demand refresh from on prem database if user is added in the ad group which gives appropriate permission to the database? I mean it works in excel desktop application but would it work the same way in Excel online too? The issue with current on prem data gateway is it runs from local machine rather then running from vm instance so the gateway can't be guaranteed to be running all the time from local machine. We want users to be able to refresh the power query dataset if they are connected to the network so excel desktop application works fine in that manner but having E5 license for that comes with its own cost I was wondering if the same is possible with F5 licensing where it only allows office online version.