105 - Update Power Query with VBScript or Powershell

Описание: Making a file you can double-click to update a Power Query-query.
I handle turning off (and on) background updating. The final script restores the original state of background update.

I also get bullied by VBScript for being Danish.


00:29 Power Shell, simply sleeps
01:45 Running method 1
02:13 VBScript, simply sleeps
04:04 Method 2 - Turn background update off then on
05:19 Get the full name of your query
07:21 You can execute the code in Power Automate Desktop
07:51 Refer to query by index
08:45 Restore previous state of background update