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