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 ...
Actually, SPO has been using Excel Online (not Excel Services) for quite some time now. The Excel Services capabilities were moved over. Excel is still totally viable (and will be moving forward). It's a first class citizen and in most cases the preferred one for analysts. It works quite well with Power BI - it's really a better together story.