Forum Discussion

AUaero's avatar
AUaero
Responsive Resident
6 years ago
Solved

Powershell Get-PowerBIWorkspace filter argument

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! 

Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    6 years ago

    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.

3 Replies

  • v-lionel-msft's avatar
    v-lionel-msft
    Community Support
    6 years ago

    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's avatar
    v-lionel-msft
    Community Support
    6 years ago

    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's avatar
      AUaero
      Responsive Resident
      6 years ago

      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.