Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
We are using PowerBI and embedding reports for users in our application using PowerBI javascript API. We have a role for RLS in the reports and we are using Direct Query to connect to our on premise oracle instance.
The problem we are facing is we have slicers in the reports and there is no option to select the default value of the slicer. When the user first accesses the page all the visualizations are loaded fully without any filter. This is resulting in slowing down of the report rendering. We are also not able to select any default value for the slicer because the data in the slicer is different for different users. If we can make the selection in a slicer mandatory or loading the slicer with defaults probably using a Javascript API would help but I was not able to find any workaround in order to achieve the same.
Any suggestions on how to handle this scenario would be helpful.
Thanks
Have you checked the following article?
Embedding with Row Level Security
https://docs.microsoft.com/en-us/power-bi/developer/embedded-row-level-security
Further, Power BI JavaScripts API allows to apply fitlers directly to the report, page or visual levels:
https://github.com/Microsoft/PowerBI-JavaScript/wiki/Filters
Leaving Default value for a slicer is currently not supported, see the idea below:
Regards,
Michael
Hi Michael,
Thanks for your reply.
We need the end user to select the values they need in the slicer. We are not exposing the filters to the users. So we cannot apply filter using PowerBI Javascript API to the reports. What we need is default selection in the Slicers which is answered by your third link.
Thanks
User | Count |
---|---|
15 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
18 | |
11 | |
5 | |
4 | |
3 |