Have this File that contains my report embedded inside an HTML web page, But its showing me different data labels when I pass of my filters, it shows me some extra date range with the exact filters that I pass!
Can Sombody suggest me different approach that I can use to achive this scenerio, I have attache here the Link of the report.
<html>
<body>
<h2>PowerBI Embedded Report</h2>
<form action="/action_page.php">
<input type="text" name="sdate" placeholder="Start Date"><br>
<input type="text" name="edate" placeholder="End Date"><br>
<input type="submit" value="Submit">
</form>
<script type="text/javascript">
window.onload = function () {
var models = window['powerbi-client'].models;
var embedConfiguration = {
type: 'report',
accessToken: 'H4sIAAAAAAAEAB1WNQ7sCBK9y089kplGmsBtZsbMTG1mr_bu27NZBS-pR1X_-WOlz3dKiz9__3GrztTbV6bbZghBCpgOzDIbNiCLyGb7MxAU4KLGe9nyiogXolpWiFjD4yICYDcvybLoPSW2Y6r1vQze6fWJy741AVusBT5hofcwzmdAX94QIuAHaB0uZ2fqyhbZebMCOX2bSuXQ1goE2eLzyME-d5QZ9dkty-yANjV9XYWvaemZMpiobhcFtvP78TfDryyVQc6-SeJFNEyRwIYVvXRkYFiPtHrta-fciWDA6shvib7kGrDDBsE1D0LITFP3ePUpyGM1EHM7GW3tFc0djAnuIreobVA1qDcOhOaswjIjWelnpG7iWwgf5OGGxfqoh1CJj5sYQifaIY0-vEQ8RwAekJQcCAymLJnRRc_249J7uxPI8OzRAko5Ybr0rNxZdnTiZH5erIFD4TnhT452YWQ2F1MRLJV-OiVb4iSLxNnix8I7AYQ8ogR5KdHExpIxdRqGRMt_6C9KlmvXTc1ZzuX0svbyXWAC9kGzWBhA6zZ8ZE1nCZbX0eEd36kd6trQRajpYD2i-6JuYFodWD-TX9CAlRFTzgvsepggWQv6eLBREixhbsisFUw2IWsFSZhsfdK8gPfp64Yuv11VS0uj7EFyhQggST8YiuV6KpFoBd62m-cwPNwkccND1VTxHUKagQtjfZakBaJaEhP8YKJieA_tW0Zw9cgxpWXIQedCI-pa5BVVIdkthnFX1wzEZdx2qkCSao28tF0yVM_jRecY5OBGnWc0FJeLYKdGJfc318hnbt0sBJS5Vwrou9J6zkncOfNygFE0fF9JDYYjjDUDhPZHy9JHB_QF71zkxG5SZ7d1wThG3i8Wna2isabz5Zb5-WYjfacteUJUqa93cBb4LTMkSJnVCjXBjYlNgfVLAmGRPKYVpqjOuwg6_N3IcCY_FnhLeTcE-Sr1ov-e36VLW_iNdCxw5haNrQJwrDx7ySBOaRu7rKqGO4rsFuxOEhKE5TylqcLjWEtjw09LaY27B9tY0HRaQEmnLg7mgibtTjnSX0Do7q9PC8i9rGqhQY4G75iCWspXRooeLUPIgPXLpUjuE6ZUwImfnQNuBbHbDYWMn-JLzhjQFOf9zdfqF9paGTAWSElhc2D78ng8RPOo8HmLFVwOOt2ClbxKpZeHhLhIb0xJUP6qqpQPVbRnNDqTKtHQ7eIiPEAdmO6bgZWY81Yvwi8SEWNaqXvngIGXUHQGybZUQn_eFH2txihi6aeRL8NZLd6LYscX-Yd1f14I0U8_okK4wwdHv9eTSl1JgY0aBgPJftoBrA7aItckbrc431P6pdKTN6L22FvRb3gpQFxFCa8ZnBEeW0nfu4XDy_L4SzwNcbd5nly6vi3tzYCr_wlgGcjJBq-LsTdVQi9ctHGpcTFW0_Y680ZNca-p_hbMW3Ruqrg6y5pJxthYuRZNDSNQqFMjar9otyXqCFBCWDCOjVkLRLtlOdsVR2eNKlcIat_RGTqr_K1ANoq_XWgx5KHICp586MA-ndOW_Bv_fkyaYN3kMpcHv0s7zPQvLA0uAfGW1Bl4FznJNvL7cXlK1GCrDLEmX7SCh8Y-1cskajFgKlgxFFexmTpgxFWBoDYBl9Cu8BoTYmau6zsXcATHbd5a8BrYLaNg1FtqCfm3Ehpft4shtBaW3y5nBO4GrDrMvoFamdambCBhqSCwQwvs1QYYnlhQM9eo1O8y6xchPo7QOCspP0d6lWFMYRAlGM8Ox4KiuU1z4AE2BwF2MNZRPQck6lKUNsL62VW4zT2_TEsf_yrTiYv2ZQLQ6VXvu2gRr36_x5d1oeCQ5AIdm932P4XdrDGgqiR-WNgnZzOVYIssVSLYFIMd6Rn2Dgzk7FhXLV9c05t4OUl424FFSHuUJ51bh357eT8zUnN9rb9iz7i1XldRPs2EfY_yVYE3owQpCUn_Qwm_gYNQVlPsjdB4J-MGuVimAW1ocw-KUmVQqcSE-uKnGabS5fV1F0eEjlN2ZRcSKVQDyGCGXwPsr0Uk-1GHbb0iB3mwB7J3dCHyyTV18pZPOkorBDng3fy7xh9rpWuxpLj9Eh-qU-LfYeJTIDfPe6juskr6P3_9Yddn3ie1fH7vQNuMKbU5xRzusViH-0cjQOY4ZrhCje2wI3XFzkJuBQ7_Lsj6mDndrXHkj0ZwSkmaIfqcvWnf6upkI6R4b1D2PlbVjS_60A_65il4wFjuNiiiEf3qnzoD95AFvswiona9gl-gavmNepT5XovzSUvUvxDNL8kbDfEZXvIU3qRc4AlEb0dIiM8itcgTu0kLLyRhucv6KuNgn76AQLF1t13mRFXjMB5ymqYPUurxIpETujjJ7CLkbDAjflp5nm5ckjjhARjq_sS7kmBAgUzbFkFYID8znTQDKCQ0as9NmxEJ8ayD69Kg7YOr_hE1EJk9PehApIA7OCiltFHjUU-p0aCYwPxe__zzL83P3JSrHPxYjp4Uhtmr29ZccmxbJk5qvuz_o9y2HtP9WMsfzGnLEtiYmxTFhyPk3iJfoeyM83sO75DrODt6PONLRNFgRn8Fa21wXNjFNGkWfSjI5ISwntcBNcYpA-rsXWwjYH0yq5EWPQRY5qdFoBK_R3Aq1fNiFDGSoAPlQJVecBhEn1DNxpAXzvJzi4e4EzlRp7Y4TSbJlrcNBBWz-XrcExjBQN-K1tVFLrSsZDHIaEhmG5XNSdH80J34yfcPUuCcZkT70-zTG8XRbns3b-ZT7F1O9PtDWgBVhlM7suOUyovzlERLbNbLjVA3YYgb0cXgJ0NZC1_ZPooaX7QkFNslcUjKUVa3hh0QttWrpCeCO50Aqd1845CcHnvxczFRAek7Exr8rxj__R-L3HG3AgsAAA==',
id: 'ec9809cd-28ca-4553-b08b-614423904eef',
tokenType: models.TokenType.Embed,
embedUrl: 'https://app.powerbi.com/reportEmbed?reportId=ec9809cd-28ca-4553-b08b-614423904eef&groupId=a78aa4c1-f...'
};
var report;
var $reportContainer = $('#reportContainer');
report= powerbi.embed($reportContainer.get(0), embedConfiguration);
var Filter1 = {
$schema: "http://powerbi.com/product/schema#advanced",
target: {
table: "reporting_validation_agg_group",
column: "aggregation_end_date_local_1"
},
logicalOperator: "AND",
conditions: [
{
operator: "LessThanOrEqual",
value: "11/20/2017"
}
]
}
var Filter2 = {
$schema: "http://powerbi.com/product/schema#advanced",
target: {
table: "reporting_validation_agg_group",
column: "aggregation_end_date_local_1"
},
logicalOperator: "AND",
conditions: [
{
operator: "GreaterThan",
value: "11/10/2017"
}
]
}
report.on('loaded', event => {
report.getFilters()
.then(filters => {
filters.push(Filter1);
filters.push(Filter2);
return report.setFilters(filters);
})
.catch(errors => {
debugger;
console.log(errors);
});
});
}
function reloadreport(){
var $reportContainer = $('#reportContainer');
powerbi.embedNew($reportContainer.get(0), embedConfiguration);
};
</script>
<script src="jquery.js"></script>
<script src="es6-promise.js"></script>
<script src="powerbi.js"></script>
<div id="reportContainer"></div>
</body>
</html>
on:
BUG: report connected to deleted semantic model ca...