Blog Post
New in Excel for the web: Power Query Refresh & Data Source Settings for authenticated data sources
Hi SergeiBaklan ,
We are gradually releasing features and will share a formal update once we are ready.
Regarding Data Source Settings, please drop me an email/message with details.
Thanks!
Hello jokahati . It would be more usefull if MS would consider providing a way for (indirectly) refreshing powerqueries in Online-Excel with cloud-power-automate or at least office scripts (not everyone has Power Automate Desktop...). While this feature that was shown above is nice, it's more of a nice-to-have instead of beeing actually usefull stuff that users have been actually demanding on numerous occasions. Same strategy is applied to almost all Power-Platform tools (except maybe BI which - besides the not-so-unecessary CoPilot push from MS side - has been favored due to MSs investments in the Fabric solution). Instead of focusing on core-features that still don't work properly (eg. modern table control in Powerapps or lack of connectors and new-designer display issues in Power Automate) even if they were offcialy released a long time ago, efforts are being directed on this sort of stuff.
Quite a weird managment/marketing choice to be honest... .
Best Regards!