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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
stevenamani
Advocate II
Advocate II

Filter Not Working (Javascript API)

I am using the Javascript API to embed a powerbi report however the filter is not affecting the result. The code is as follows:

 

function getFilters () {
const filter1 = {$schema: "http://powerbi.com/product/schema#basic",target: {table: "Users",column: "ID"},operator: "In",values: ["470"]};
var allFilters = [filter1];
return allFilters;
}

 

The above function is called from an updateEmbededDashboard function that contains

 

 report.getFilters()
                    .then(function(filters) {
                        
                        var allFilters = getFilters();

                        filters.push(allFilters);
                        
                        if (allFilters != null) return report.setFilters(allFilters);
                    }).catch (function (error) {
                        console.log(error.message);
                    });
1 ACCEPTED SOLUTION
stevenamani
Advocate II
Advocate II

In case anyone else comes accross this:

 

The issue was having the numeric value in double quotes. Instead of 

 

 

operator: "In",values: ["470"]};

It should be

operator: "In",values: [470]};

 

View solution in original post

1 REPLY 1
stevenamani
Advocate II
Advocate II

In case anyone else comes accross this:

 

The issue was having the numeric value in double quotes. Instead of 

 

 

operator: "In",values: ["470"]};

It should be

operator: "In",values: [470]};

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.