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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

Top Solution Authors