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 ...
John White can you share more information on how to configure Excel Online to access on-premise SQL Data. And does that also apply to Mac Office 365 Excel. I have attached an error I received when I tried refreshing excel online that is connected to an On-premise SQL Server
How Excel is connected, Power Query?
SergeiBaklan Yes, I am using Power Query
To my knowledge Excel Online doesn't support PQ refresh. That's use desktop app, or publish on Power BI (file shall have data model) and refresh from it, better use scheduled refresh. Another option is to use Flow to refresh such file.
SergeiBaklan That's right - you need to connect the file to Power BI to facilitate and schedule the refresh - Excel Online doesn't do it on its own
