Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
2 | |
2 | |
1 | |
1 |
User | Count |
---|---|
20 | |
3 | |
2 | |
2 | |
2 |