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.
Hi,
I am integrating power bi to my web application , So i have 5 Types diffrent stores which are able to select from application that stores are also available in my dataset in power bi . So now i need wheather we can pass the parameters from application to power bi to filter according to stores selected from the application .
Is this possible
??????????????????
Solved! Go to Solution.
@chotu27 wrote:
Hi,
I am integrating power bi to my web application , So i have 5 Types diffrent stores which are able to select from application that stores are also available in my dataset in power bi . So now i need wheather we can pass the parameters from application to power bi to filter according to stores selected from the application .
Is this possible
??????????????????
It is possible, you could use the Power BI Javascript API, see Filters. A demo for your reference. Note that the table name and column name are case sensitive.
<html> <script src="JQuery.js"></script> <script src="powerbi.js"></script> <script type="text/javascript"> window.onload = function () { // Read embed application token from Model var accessToken = "H4sIAAxxxxxxxxxxxxxuoLAAA="; // Read embed URL from Model var embedUrl = "https://app.powerbi.com/reportEmbed?reportId=5146cfxxxxxa469caab581&groupId=dc581184-xxxx32f16b6c15"; // Read dashboard Id from Model var embedReportId = "51xxxaab581"; // 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 filter1 = { $schema: "http://powerbi.com/product/schema#advanced", target: { table: "Table1", column: "storename" }, logicalOperator: "OR", conditions: [ { operator: "Contains", value: "store1" } ] } var config = { type: 'report', tokenType: models.TokenType.Embed, accessToken: accessToken, embedUrl: embedUrl, id: embedReportId, filters:[filter1], // the filters is an array here, you can add more filter like [filter1,filter2,filter3] settings: { filterPaneEnabled: true //hide the filterPane so that your user can't change the filter to see more data, this is not a strong security, anyone who's familar with javascript can bypass it } }; // Get a reference to the embedded dashboard HTML element var dashboardContainer = $('#reportContainer')[0] ; // Embed the dashboard and display it within the div container. var dashboard = powerbi.embed(dashboardContainer, config); } </script> <div id="reportContainer"></div> </html>
@chotu27 wrote:
Hi,
I am integrating power bi to my web application , So i have 5 Types diffrent stores which are able to select from application that stores are also available in my dataset in power bi . So now i need wheather we can pass the parameters from application to power bi to filter according to stores selected from the application .
Is this possible
??????????????????
It is possible, you could use the Power BI Javascript API, see Filters. A demo for your reference. Note that the table name and column name are case sensitive.
<html> <script src="JQuery.js"></script> <script src="powerbi.js"></script> <script type="text/javascript"> window.onload = function () { // Read embed application token from Model var accessToken = "H4sIAAxxxxxxxxxxxxxuoLAAA="; // Read embed URL from Model var embedUrl = "https://app.powerbi.com/reportEmbed?reportId=5146cfxxxxxa469caab581&groupId=dc581184-xxxx32f16b6c15"; // Read dashboard Id from Model var embedReportId = "51xxxaab581"; // 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 filter1 = { $schema: "http://powerbi.com/product/schema#advanced", target: { table: "Table1", column: "storename" }, logicalOperator: "OR", conditions: [ { operator: "Contains", value: "store1" } ] } var config = { type: 'report', tokenType: models.TokenType.Embed, accessToken: accessToken, embedUrl: embedUrl, id: embedReportId, filters:[filter1], // the filters is an array here, you can add more filter like [filter1,filter2,filter3] settings: { filterPaneEnabled: true //hide the filterPane so that your user can't change the filter to see more data, this is not a strong security, anyone who's familar with javascript can bypass it } }; // Get a reference to the embedded dashboard HTML element var dashboardContainer = $('#reportContainer')[0] ; // Embed the dashboard and display it within the div container. var dashboard = powerbi.embed(dashboardContainer, config); } </script> <div id="reportContainer"></div> </html>
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 |
---|---|
14 | |
2 | |
2 | |
1 | |
1 |