Forum Discussion

nazanael1's avatar
nazanael1
New Member
2 years ago

Power BI embedding - Set and replace filters at embed time (config object)

Hello,   We are trying to embed a Power BI report into our web application. That report has a filter that we want to overwrite at embedding time. We want to use the OnLoadFilters interface from IR...
Need Help
nazanael1's avatar
nazanael1
New Member
2 years ago

Hello,

Although it's a good idea it's not what we really want to do, as it would involve using bookmarks just to have 1 filter. What we want to achieve is to send a filter in embedding time, replacing the default one, without having to wait until the report is loaded. Is this possible somehow?

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi nazanael1,

    I check the document about embedded config and find it include filters option, I think you can use it to setting the filters:

    Configure embedded Power BI report settings in a Power BI embedded analytics application | Microsoft Learn

    Use filters when embedding a report in Power BI embedded analytics | Microsoft Learn

    var basicFilter = {
  $schema: "http://powerbi.com/product/schema#basic",
  target: {
    table: "Table",
    column: "Column"
  },
  operator: "In",
  values: [1, 2, 3, 4]
}

var config = {
  type: 'report',
  accessToken: 'access-token',
  embedUrl: 'https://app.powerbi.com/reportEmbed?reportId=report-id',
  filters: [basicFilter]
};

var reportContainer = $('#reportContainer')[0];
var report = powerbi.embed(reportContainer, config);

    Regards,

    Xiaoxin Sheng

    • nazanael1's avatar
      nazanael1
      New Member
      2 years ago

      Hello,

      That is what we want to do. The issue doing it this way is that it does not overwrite the default filter. In the image, the report after being embedded. In the original report, the Filter is set as "Light".

      Doing what you explained, I changed to "Dark", but it is not being replaced, just adds it twice (Even having Require single selection).

       

      Original (Power BI Service)

       

       

      Embedded: After adding "Dark" in the config

       

      We expected here to remove the Light and add the Dark filter.

       

      That is why I wanted to use ReportOnLoadFilters, to be able to replace the previous one.

       

      Is there any way to replace it using the config object?