Forum Discussion
Excel Services and On-Premises SQL Data
I am looking to have an active data connection from an Excel file in Excel Services on SharePoint Online (O365) that has a data connection to an on-premises SQL database. Need to be able to have ...
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.
I have tried this multiple times. If you still are monitoring this thread I sure would appreciate some help to understand how you accomplished this.