cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

Dynamic filtering on Power BI Embedded

 

I have a report Embedded on my internal application, and i want filter based on user/group login to show the data, unfortunatly its not running very well, the report showing well but its not filtering as it code.

 

Below is my javascript code on embed powerBI, please do help me to solved this issue or anything would very appreciated.

 

<script>


    // Read embed application token from Model
    var accessToken = "@Model.EmbedToken.Token";

    // Read embed URL from Model
    var embedUrl = "@Html.Raw(Model.EmbedUrl)";

    // Read report Id from Model
    var embedReportId = "25f8b577-81fd-4769-8a3f-XXXXXXXX";

    // Get models. models contains enums that can be used.
    var models = window['powerbi-client'].models;

    // Embed configuration used to describe the what and how to embed.
    // This object is used when calling powerbi.embed.
    // This also includes settings and options such as filters.
    // You can find more information at https://github.com/Microsoft/PowerBI-JavaScript/wiki/Embed-Configuration-Details.



    var config = {
        type: 'report',
        tokenType: models.TokenType.Embed,
        accessToken: accessToken,
        embedUrl: embedUrl,
        id: embedReportId,
        pageView: "oneColumn",
        permissions: models.Permissions.All,        
        pageView: "oneColumn",
        settings: {
            filterPaneEnabled: true,
            navContentPaneEnabled: false
        }
    };

    var reportContainer = $('#reportContainer')[0];

    var report = powerbi.embed(reportContainer, config);

      var basicFilter = {
        $schema: "http://powerbi.com/product/schema#basic",
        target: {
            table: "M_Merchants",
            column: "Merchant_ID"
        },
        operator: 'In',
        values: "['119','120']",
        filterType: 0 
    };

    report.getFilters().then(function (allTargetFilters) {
        allTargetFilters.push(basicFilter);

        // Set filters
        // https://microsoft.github.io/PowerBI-JavaScript/interfaces/_src_ifilterable_.ifilterable.html#setfilters
        report.setFilters(allTargetFilters);
    });

   
</script>

Thanks,

Thomas Benny

1 REPLY 1
Highlighted
Regular Visitor

Re: Dynamic filtering on Power BI Embedded

<script>


    // Read embed application token from Model
    var accessToken = "@Model.EmbedToken.Token";

    // Read embed URL from Model
    var embedUrl = "@Html.Raw(Model.EmbedUrl)";

    // Read report Id from Model
    //var embedReportId = "25f8b577-81fd-4769-8a3f-8383bbd5c176";
    var embedReportId = "44adc0f5-fafe-488d-b948-d1f78054456d";
    // Get models. models contains enums that can be used.
    var models = window['powerbi-client'].models;

    // Embed configuration used to describe the what and how to embed.
    // This object is used when calling powerbi.embed.
    // This also includes settings and options such as filters.
    // You can find more information at https://github.com/Microsoft/PowerBI-JavaScript/wiki/Embed-Configuration-Details.

    const basicFilter = {
        $schema: "http://powerbi.com/product/schema#basic",
        target: {
            table: "M_Company",
            column: "Company_ID"
        },
        operator: "In",
        values: [2],
        filterType: 0
    };
    var config = {
        type: 'report',
        tokenType: models.TokenType.Embed,
        accessToken: accessToken,
        embedUrl: embedUrl,
        id: embedReportId,
        pageName: 'M_Company',
        permissions: models.Permissions.All,
        filters: [basicFilter],
        settings: {
            filterPaneEnabled: false,
            navContentPaneEnabled: false
        }
    };

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

    //Add filter to the report
    report.on('loaded', event => {
        report.getFilters()
            .then(filters => {
                filters.push(basicFilter);
                return report.setFilters(filters);
            });
    });
  
</script>

when i add the filter on config, it continues loading with no end, I really dont undertand about this please somebody help me.

Helpful resources

Announcements
Meet the 2020 Season 2 Power BI Super Users!

Meet the 2020 Season 2 Power BI Super Users!

Find out who's part of the program this season, and welcome the new Super Users.

August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

July 2020 Community Highlights

July 2020 Community Highlights

Learn about the exciting things that happened in July.

Featured Data Story of The Month

Featured Data Story of The Month

All Data Stories Gallery contributions are reviewed for each month. We select a contribution and feature the community member the following month.

Power BI Dev Camp - Developing with .NET Core

Power BI Dev Camp - Developing with .NET Core

Learn how to develop custom web applications for Power BI using .NET Core 3.1 and .NET 5.