Powershell Get-PowerBIWorkspace filter argument

[AUaero]

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! 

[v-lionel-msft · Accepted solution]

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.

[v-lionel-msft]

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.

[AUaero]

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.