Powershell Script PowerBI Invoke REST API Method Filter Configuration

[EricShahi]

My report configuration filter is not hitting the right table/column. Is there any reason something in not right here? should I avoide having spaces on my table name ?

 $pteam = "Accounting"

 $body = "{ format : `"PDF`",
 powerBIReportConfiguration : { reportLevelFilters : [{ filter : `"Department (measures)/Team 
 eq '$pteam'`" }]}}"

[EricShahi]

used encode for the open and closed brackets no luck ....

?filter=Department_x0020_x0028_measures_x0029/Team eq 'Accounting'

[EricShahi]

@GilbertQ 

Thanks for this.

I tried to add below filter on my URL, but its not working, Is it something to do with the brackets "(measures)"

?filter=Department_x0020_(measures)/Team eq 'Accounting'

[GilbertQ]

Hi @EricShahi 

I would suggest looking at the link below which references how to handle spaces ?

Filter a report using query string parameters in the URL - Power BI | Microsoft Learn