Dynamic filtering on Power BI Embedded

thomasbenny — Tue, 21 May 2019 09:54:36 GMT

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

Re: Dynamic filtering on Power BI Embedded

thomasbenny — Tue, 21 May 2019 15:37:36 GMT

<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.

topic Re: Dynamic filtering on Power BI Embedded in Developer

Dynamic filtering on Power BI Embedded

Re: Dynamic filtering on Power BI Embedded