Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Solved! Go to 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.
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.
Hi @AUaero ,
Please refer to the article.
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.
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.
User | Count |
---|---|
13 | |
5 | |
2 | |
1 | |
1 |
User | Count |
---|---|
26 | |
3 | |
3 | |
2 | |
2 |