Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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'`" }]}}"
used encode for the open and closed brackets no luck ....
?filter=Department_x0020_x0028_measures_x0029/Team eq 'Accounting'
@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'
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