Using Power BI Rest APIs with Filters in Powershell

[crturner]

I am attempting to call the Get Groups REST API in Powershell to obtain a list of all the workspaces I have access to. 

$GetWorkspaces = Invoke-PowerBIRestMethod -Url "https://api.powerbi.com/v1.0/myorg/groups/" -Method Get 

I would like to add a filter on the workspace name, i.e., only return workspaces that include that word "email" in them. I've used the try it function, and tried to edit the url string, but nothing seems to change the result set from returning every workspace. Appreciate any thoughts!

[GilbertQ]

Hi @crturner 

I would try and use the Try it now in the PBI Service to see what works, what does not work?

[crturner · Accepted solution]

The Try it now feature is great, and I've been testing it, but I was getting syntax errors.

If anyone else is struggling with this, set the name/value as $filter/contains(name,'text')

[GilbertQ]

Hi @crturner 

Here is an example with the API where you can apply the filter

Groups - Get Groups - REST API (Power BI Power BI REST APIs) | Microsoft Learn

[crturner]

Hi @GilbertQ I've seen that example and tried it

$GetWorkspaces = Invoke-PowerBIRestMethod -Url "https://api.powerbi.com/v1.0/myorg/groups?$filter=contains(name,'email')" -Method Get

But I still get the entire result set back

[jmartel]

Do you have any error while running it? give me infos. thanks!