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'v...
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.

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.