microsoft / vscode-mssql

Visual Studio Code SQL Server extension.
Other
1.55k stars 459 forks source link

Search Azure subscriptions not working #18240

Closed amthomas46 closed 3 weeks ago

amthomas46 commented 3 weeks ago

Please add "Area" label and repro steps before submitting.

I logged in with Azure (was prompted by the extension to log in) but typing doesnt narrow the subscriptions

Image

amthomas46 commented 3 weeks ago

i used the other filtering option but nothing shows up for RGs Image

Benjin commented 3 weeks ago

After some investigation, I found that I was getting an error message saying that the resource filter argument I was passing for server-side processing was invalid... for some subscriptions, but not all (or even most). Curiously, it was consistently the same subscriptions that would return the error, and I didn't notice any pattern to it. My mind went to permissions, but the query for all resources under that sub is consistently working fine for all subs so that doesn't make sense.