Forum Discussion

kosmik5's avatar
kosmik5
Regular Visitor
8 years ago
Solved

Power BI Embedded Parameters and Filter

Hi, We are developing a Power BI embedded app, where we have an Azure website containing a Power BI report, which is also uploaded to our Azure server. I know I can set filter parameters in a Power...
Need Help
Tips and Tricks
  • v-ljerr-msft's avatar
    v-ljerr-msft
    8 years ago

    Hi kosmik5,

     

    You should be able to use PowerBI-JavaScript API to set filters with Power BI Embedded. For more details, you can refer to PowerBI-JavaScript wiki Filters. :smileyhappy:

    const filter = { ... };

report.setFilters([filter])
  .catch(errors => {
    // Handle error
  });

    Sample of filters:

    const basicFilter: pbi.models.IBasicFilter = {
  $schema: "http://powerbi.com/product/schema#basic",
  target: {
    table: "Store",
    column: "Count"
  },
  operator: "In",
  values: [1,2,3,4]
}

     

    Regards

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
8 years ago

Hi kosmik5,

 

You should be able to use PowerBI-JavaScript API to set filters with Power BI Embedded. For more details, you can refer to PowerBI-JavaScript wiki Filters. :smileyhappy:

const filter = { ... };

report.setFilters([filter])
  .catch(errors => {
    // Handle error
  });

Sample of filters:

const basicFilter: pbi.models.IBasicFilter = {
  $schema: "http://powerbi.com/product/schema#basic",
  target: {
    table: "Store",
    column: "Count"
  },
  operator: "In",
  values: [1,2,3,4]
}

 

Regards