Forum Discussion

AdenikeElemo's avatar
AdenikeElemo
Regular Visitor
2 years ago

RLS Enabled Report

I have an RLS enabled report based on country filtering. Because the Country slicer is single select, I have to have a default country selected before publishing the report. After all the steps, if for example default country is Belgium and a User from France want to access the report, s/he will be confronted with a blank report because s/he had no access to the default view which is Belgium before a selection of the country is made from the filter which will now populate the report. How can I enable different default view for each Country such that Users from a specific country will see a default view relative to their country instead of a blank report?

Need Help
Tips and Tricks

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    In short, you can't.  A common work around is to add an additional entry to your country dimension that says something like "<Please Select A Country>" such that everyone starts with a blank report.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.

    • AdenikeElemo's avatar
      AdenikeElemo
      Regular Visitor
      2 years ago

      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.

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        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