Forum Discussion

Prarav's avatar
Prarav
Helper I
1 year ago

Power BI - RLS

I need assistance with the following scenario:   I have a Power BI report. In my dataset I have two tables. Table -1: REQ table Columns: REQ No, URL(Web-url), PrimaryID(GUID), SecondaryID...
Need Help
Show and Tell
Tips and Tricks
Prarav's avatar
Prarav
Helper I
1 year ago

 I followed your steps and tried but still not working. It is showing blank report for non POC users.

Thank you. 

Anonymous's avatar
Anonymous
Not applicable
1 year ago

HI, Prarav 
Thank you for your prompt response.

 

Could you please provide details on what your expected output should look like? I suspect there may be a misunderstanding on my part regarding your question, and I would appreciate it if you could clarify the following:

 

1.What are the results from the perspectives of Primary and Secondary users compared to those of other users?

2.How do we determine which users fall under the category of 'other users'? Am I correct in understanding that this refers to users who have a UserID but do not have a PrimaryID?

 

I hope you can answer my questions, as this will help me better understand your issue and propose a more suitable solution for you.

 

For questions about uploading data, you can try the following links:

How to provide sample data in the Power BI Forum - Microsoft Fabric Community

Solved: How to upload PBI in Community - Microsoft Fabric Community

 

When uploading a file, please be careful to delete sensitive information.

 

Best Regards,

Leroy Lu

  • Prarav's avatar
    Prarav
    Helper I
    1 year ago

    Hi Lu,

    I appreaciate your help. Please see my answers below in blue text

     

    1.What are the results from the perspectives of Primary and Secondary users compared to those of other users?

     

    Primary and Secondary users should be able to see all Request Numbers as plain text. However, the Request Numbers that belong to them should appear as hyperlinks.

    Something like:

    1. Scenario

    OR

    2. Scenario. I would like to display something like following screenshot.

     

     

     

    2.How do we determine which users fall under the category of 'other users'? Am I correct in understanding that this refers to users who have a UserID but do not have a PrimaryID?

     

    Users who are not assigned as Primary POCs or Secondary POCs should see the Request Numbers as plain text when they open the report.

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      Hi, Prarav 

      Thank you for your prompt response.

      Based on your latest reply, I have updated my solution as follows:

       

      1.Firstly, I have created the following measures:

      Measure = 
VAR ccc1=CALCULATETABLE (
        VALUES ( 'USER'[domainname (email)]),
        FILTER ( ALLSELECTED ( 'USER' ), 'USER'[userid (GUID)] IN VALUES('REQ'[PrimaryID (GUID)]) )
    )
VAR No1 =
    CALCULATETABLE (
        VALUES ( 'REQ'[REQ No]),
        FILTER ( ALLSELECTED ( 'REQ' ), 'REQ'[PrimaryID (GUID)] IN VALUES(USER[userid (GUID)]) )
    )
RETURN
   IF(USERPRINCIPALNAME() IN ccc1,IF(MAX('REQ'[REQ No]) IN No1,MAX('REQ'[URL]),BLANK()),BLANK())

      2.Secondly, I have modified the settings in the visualization:

      3.Here are the final results:

       

      When the user is a Primary and Secondary user:

       

      When the user is another type of user:

      Please note that the USERPRINCIPALNAME() function returns the email address you are currently using.
       

      Please find the attached pbix relevant to the case.

       
       

      Best Regards,

      Leroy Lu

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.