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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors