I'm not really sure how to do this, basically, we have a DB in Azure that I need to run a query against, however, it fails to access being restricted for only internal sources. When I create the "SQL Server User Experience Monitor" I set the "Test Node" to be the Azure DB, but apparently, it also tries to run the Query from that server. There isn't an out of the box way to separate the two. I did read that a Powershell script may be able to acheive this, but I pretty much suck at Powershell and would greatly appreciate any help with this.
Please let me know if any additional details are needed and thanks again for any help given.