There are many approaches to filter one table with another using Power Query. The most common solution I found was to join tables together, and then delete the resulting joined results. This feels like a poor solution, and reviewing Table.Contains, this seems like a good way to provide filtering
I'm learning about application development, and I rarely see beginner topics discuss security for an application as you begin development. I've found that using environment variables to keep your secrets safe is an effective way to use source control and not commit your passwords or expose other material you want
To call a PowerShell (PS) script from another PowerShell script and have it run in a second terminal window without exiting, you can use a script similar to:
Start-Process PowerShell.exe -ArgumentList "-noexit", "-command .\local_path\start_server.ps1"
When developing in Visual Studio Code, I