RLS Enabled Report

[AdenikeElemo]

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?

[Anonymous]

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 @RossEdwards  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]

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]

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

[AdenikeElemo]

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!

[RossEdwards]

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.