Forum Discussion

stevenamani's avatar
stevenamani
Advocate II
8 years ago
Solved

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

     

1 Reply

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