Forum Discussion

Calvin69's avatar
Calvin69
Helper III
3 years ago
Solved

RLS with Blanks

Hi experts, I have a report that uses the RLS feature. I established an external Excel sheet that lists all users names, emails, departments & Projects and linked to my code in RLS: In the c...
Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    Calvin69 , Try like

    [email] = userprincipalname() || isblank(Table[department Project])

RobinSellow's avatar
RobinSellow
Frequent Visitor
2 years ago

Hi,

I have a problem with RLS in combination with blank cells. Hopefully you can help me. I have a RLS table and a services table. In the services table are some blanks. But this is information that also is important. I tried this: [E-mailadres] = USERPRINCIPALNAME() || isblank(fact_services[decl.id]), but this is not working. I also tried this in de services table, but unfortunately without succes. 

Is it possible to add a filter in every table to see the blank data with RLS? 

Can someone help me? 

Calvin69's avatar
Calvin69
Helper III
2 years ago

HI RobinSellow , do you have a sample file that you could share with us to work this out?

  • RobinSellow's avatar
    RobinSellow
    Frequent Visitor
    2 years ago

    Hi all,

     

    Here is how my dataset is built. I have a RLS table with user names, emailadressess and regions (id's). Every user may see an other region, so the dataset if filtered at region level. My RLS table is connected with the region table. The region table is connected with the facilitites table. Because in the region, there are multipe facilities active. And the facilities table is connected with the services table. In this table all the services are mentioned. A service can be fulfilled, then the column declaration_id is filled, but if a service is not fulfilled, than this cell is blank. But this information is also in the dashboard. The problem is that RLS is not showing blank cells, and now my data is not right. 

    How can i fix this?