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 ...
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
