Forum Discussion
RLS Enabled Report
Hi AdenikeElemo ,
First I think you need to make sure that your RLS is set up to dynamically filter the data based on the user's country. You can read this document: Row-level security (RLS) guidance in Power BI Desktop - Power BI | Microsoft Learn
Then as Anonymous said, I think you could create an initial "welcome" page that doesn't rely on a country/region filter so that the user can make some judgments before choosing.
Of course it's possible to use a bookmark, which only records the transient state but also guides your user through the selection process, here's a link to the bookmark: Create report bookmarks in Power BI to share insights and build stories - Power BI | Microsoft Learn
Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks, the report already had an RLS based on User's country but when Users want to access the report, the default state of the report which is single select may not be that of the User's country. In that case, s/he sees a blank report before selecting the country for the data to get populated. I thought I can change this behavior such that at the access point, the report will default to User's country data without first experiencing the blank page. I will explore the bookmark.
Hi AdenikeElemo ,
Have you solved your problem? If so, can you share your solution here and mark the correct answer as a standard answer to help other members find it faster? Thank you very much for your kind cooperation!
Best Regards
Yilong Zhou
Hi, thanks for asking and, NO, issue is yet to be resolved. All calculations on the report page got filtered at specific country levels and if there is no selection of the country slicer or there is select all, the report will fail. So, I need to figure out how to write the dax code that will change the default country based on user's country but I am not sure if this will work in the Power BI service. Thanks!