Filter Not Working (Javascript API)

stevenamani — Thu, 16 Aug 2018 21:08:09 GMT

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);
                    });

Re: Filter Not Working (Javascript API)

stevenamani — Fri, 17 Aug 2018 14:00:20 GMT

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]};

topic Re: Filter Not Working (Javascript API) in Developer

Filter Not Working (Javascript API)

Re: Filter Not Working (Javascript API)