topic Re: Powershell Get-PowerBIWorkspace filter argument in Developer

Powershell Get-PowerBIWorkspace filter argument

AUaero — Tue, 26 May 2020 18:49:26 GMT

Hi, this seems like it should be simple, but I'm not a Powershell expert so here goes.

I want to be able to pass two filter parameters to the Get-PowerBIWorkspace Powershell cmdlet. Here's what I've tried:

Get-PowerBIWorkspace -Scope Organization -All -Filter {("tolower(type) eq 'group'") -and ("tolower(state) eq 'active'")}

This returns a bad request from the API:

Get-PowerBIWorkspace : Operation returned an invalid status code 'BadRequest'

So, can I pass multiple filter criteria using the -filter parameter on this cmdlet?

Thanks!

Re: Powershell Get-PowerBIWorkspace filter argument

v-lionel-msft — Thu, 28 May 2020 09:16:35 GMT

Hi @AUaero ,

Please refer to the article.

Get-PowerBIWorkspace

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Powershell Get-PowerBIWorkspace filter argument

AUaero — Thu, 28 May 2020 14:35:57 GMT

Thanks v-lionel-msft. I've already reviewed the documentation on this cmdlet that you've suggested. My question is specifically on how to pass multiple filter arguments to the filter parameter of the cmdlet.

Re: Powershell Get-PowerBIWorkspace filter argument

v-lionel-msft — Tue, 09 Jun 2020 08:48:35 GMT

Hi @AUaero ,

Try this.

Get-PowerBIWorkspace -Scope Organization -All -Filter " ( tolower(type) eq 'group' ) -and ( tolower(state) eq 'active' ) "

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.