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 have a Report embedded into an MVC Web app, the problem is that my filter does not work, i have tried various methods to no avail.
<script type="text/javascript"> window.onload = function () { var Filter1 = { $schema: "http://powerbi.com/product/schema#basic", target: { table: "vw_NGO_Registrations", column: "NGOName" }, Operator: "In", values: ["BADISA"] } var config = { type: 'report', accessToken: "@(Model.Token)", embedUrl: "@Model.PBIReport.embedUrl", id: "@Model.PBIReport.id", filters: [Filter1], settings: { filterPaneEnabled: true, navContentPaneEnabled: true } }; var reportContainer = document.getElementById('reportContainer'); var report = powerbi.embed(reportContainer, config); }); }); }; </script>
I have also tried adding the following at the bottom of the script
report.on('loaded', event => { report.getFilters() .then(filters => { filters.push(Filter1); return report.setFilters(filters);
The report just keeps showing all the data, additionally, The filter pane does NOT show, i dont know if that has anything to do with it, even though i explicitly set filterPaneEnabled = true. Even when i remove the settings, it still wont show.
Even when i added the following, still no filter pane.
<div ID="reportContainer" style="width: 900px; height: 500px" powerbi-settings-nav-content-pane-enabled="true" powerbi-settings-filter-pane-enabled="true"></div>
Thank you
@cranial3 wrote:
Hi
I have a Report embedded into an MVC Web app, the problem is that my filter does not work, i have tried various methods to no avail.
<script type="text/javascript"> window.onload = function () { var Filter1 = { $schema: "http://powerbi.com/product/schema#basic", target: { table: "vw_NGO_Registrations", column: "NGOName" }, Operator: "In", values: ["BADISA"] } var config = { type: 'report', accessToken: "@(Model.Token)", embedUrl: "@Model.PBIReport.embedUrl", id: "@Model.PBIReport.id", filters: [Filter1], settings: { filterPaneEnabled: true, navContentPaneEnabled: true } }; var reportContainer = document.getElementById('reportContainer'); var report = powerbi.embed(reportContainer, config); }); }); }; </script>I have also tried adding the following at the bottom of the script
report.on('loaded', event => { report.getFilters() .then(filters => { filters.push(Filter1); return report.setFilters(filters);The report just keeps showing all the data, additionally, The filter pane does NOT show, i dont know if that has anything to do with it, even though i explicitly set filterPaneEnabled = true. Even when i remove the settings, it still wont show.
Even when i added the following, still no filter pane.
<div ID="reportContainer" style="width: 900px; height: 500px" powerbi-settings-nav-content-pane-enabled="true" powerbi-settings-filter-pane-enabled="true"></div>
Thank you
How is it going on if you run the test embedding report demo? Does the filter pane show? By the way, what is the browser in your case, have you observed anything wrong in the tab of Console and Network of browser dev mode(F12).
Hi
No Filter Pane is shown when using the embedded report demo, it displayed the report exactly as in my browser.
I am using Chrome, i installed firefox, and viewing is the same in there too, no filter pane.
I checked the console, no errors except for "Slow network is detected".
Thanks
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 |
---|---|
12 | |
2 | |
2 | |
1 | |
1 |