Forum Discussion

chotu27's avatar
chotu27
Post Patron
9 years ago
Solved

power bi embedded

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 Help
  • Eric_Zhang's avatar
    Eric_Zhang
    9 years ago
    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
    ?????????????????? 

    chotu27

    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>

     

Eric_Zhang's avatar
Eric_Zhang
Microsoft Employee
9 years ago
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
?????????????????? 

chotu27

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>