Forum Discussion
New "Automate" tab in Everybody's Excel Online Except Mine
- There are two possible fixes for this:
1. Clear out your cookies
2. Enable third party cookies (this one is mandatory for the Automate tab to appear I'm afraid)
Power Query refresh doesn't work in Excel Online (hope so far), doesn't matter if you initiate it manually or by script. Workarounds are
- refresh in desktop app
- if data is added to data model, connect file to Power BI workspace and schedule refresh in it. Or refresh manually here, or by Power Automate.
SergeiBaklan yes agreed. Trying to move away from Task Scheduler refreshes of Power Query + VBA though, and we have some use cases where Excel beats Power BI still, so really hoping automated refresh comes to Excel online.
SergeiBaklan oh right, nice idea. Hadn't thought of that.
If under automated refresh you mean scheduled one, Power BI workspace could be an option. Add data returned by Power Query to data model, connect to workspace, schedule refresh and forget about this workspace, work with Excel as usual. The only minus such refresh fails if the file is opened / checked-out by someone.