Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
10 | |
3 | |
3 | |
3 | |
2 |