Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
<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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
13 | |
2 | |
2 | |
1 | |
1 |
User | Count |
---|---|
20 | |
3 | |
2 | |
2 | |
2 |