Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
EricShahi
Helper IV
Helper IV

Powershell Script PowerBI Invoke REST API Method Filter Configuration

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'`" }]}}"

 

3 REPLIES 3
EricShahi
Helper IV
Helper IV

 

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

 

 

?filter=Department_x0020_x0028_measures_x0029/Team eq 'Accounting'

EricShahi
Helper IV
Helper IV

@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
Super User
Super User

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





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!