EmbededPowerBI react component is not filtering report data

Question

I am using PowerBIEmbed component to display powerBI report, Power BI report is using telemetry query to filter data. telemetry has columns like

name CustomColumnJson { Id, Event }

I want to apply filter over Id column, then I am applying filter like , but filter is not working.

       <PowerBIEmbed
            embedConfig={{
                type: 'report', 
                id: '*********************',  //client_id
                embedUrl: "", //embed url, if u dont knw refer powerbi api docs
                accessToken: this.state.accessToken,
                tokenType: models.TokenType.Aad,
filters: [{
                $schema: "http://powerbi.com/product/schema#basic",
                target: {
                table: "Event",
                column: "CustomColumnJson.Id"
                },
                operator: "In",
                values: "XYZ"
            }],
                settings: {
                    panes: {
                        filters: {
                            expanded: false,
                            visible: true
                        }
                    },
                }
            }} eventHandlers={
                new Map([
                    ['loaded', function () { console.log('Report loaded'); }],
                    ['rendered', function () { console.log('Report rendered'); }],
                    ['error', function (event) { console.log(event.detail); }]
                ])
            }
            cssClassName={"container"}
            getEmbeddedComponent={(embeddedReport) => {
                window.report = embeddedReport;
            }}
        />

Kotana Sai · Accepted Answer · 2022-11-11 09:20:08Z

0

Values in the filters should be of Array of (strings or boolean or numbers). Try this code and LMK if this works.

filters: [{
                $schema: "http://powerbi.com/product/schema#basic",
                target: {
                table: "Event",
                column: "CustomColumnJson.Id"
                },
                operator: "In",
                values: ["XYZ"]
            }],

Sample :

const filter = {
$schema: "http://powerbi.com/product/schema#basic",
target: {
    table: "Geo",
    column: "Region"
},
operator: "In",
values: ["West", "Central"]}; 
// Add the filter to the report's filters.
try {
await report.updateFilters(models.FiltersOperations.Add, [filter]);
console.log("Report filter was added.");}
catch (errors) {
console.log(errors);}

Here is my table and column name.

Filter section before applying filter

Filter section after applying filter

References: https://learn.microsoft.com/javascript/api/overview/powerbi/control-report-filters

edited Nov 11, 2022 at 9:20

answered Nov 11, 2022 at 6:17

Kotana Sai

1,9143 gold badges17 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

7 Comments

vam Over a year ago

Yes, I passed array by mistake I have written value, but still not filtering, but at rightside when I looked into filter then filter column is showing with "All" value not the passed filtered parameter value.

Kotana Sai Over a year ago

Can you recheck your column name whether its correct or not ? I didn't get your column name correctly

vam Over a year ago

column name is correct, do I need add applicable column name in Power BI report? I mean, PowerBI report should define the applicable filter column name in power BI filter section?

Kotana Sai Over a year ago

If I understood Your question correctly, No need to add column to filter section in powerbi. It will automatically get added to filter section when applying filter. edited my answer with snapshots. If possible can you give a screenshot of your table with columns?

vam Over a year ago

I have checked your code, you are calling update filter method, where and when to call updateFilter method? Please review my posted code also. I am passing column name correct as you mention.

|

Collectives™ on Stack Overflow

EmbededPowerBI react component is not filtering report data

1 Answer 1

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related