Get column values depending on user details

[ronaldg]

I have 2 tables here, the user details table and the learnings table.

Scenario:
I will log in as johnsmith@test.com in the dashboard, I want to get the Learning Title that matches my details(Rank, MG and SL). Or should I say I want to get the Learning Titles that are applicable to me depending on my Rank, MG and SL.
For example, 
I am johnsmith, since my rank, mg and sl matches the learning title 1's rank, mg and sl, I want to get the learning title.

Is that possible with Power BI?

[v-rzhou-msft · Accepted solution]

Hi @ronaldg ,

According to your statement, I think you can try to configure dynamic RLS in Power BI Desktop.

For reference:

Row-level security (RLS) with Power BI - Power BI | Microsoft Learn

Dynamic Row Level Security with Power BI Made Simple

I suggest you to merge [Rank]/[MG]/[SL] columns in both tables.

Merage Column = COMBINEVALUES("-",Learnings[Rank],Learnings[MG],Learnings[SL])

Merge Column = COMBINEVALUES("-",'User Details'[Rank],'User Details'[MG],'User Details'[SL])

Data model:

Configure rls in manage roles.

When you view as  johnsmith@test.com, you will only see data in "Learning Title 1":.

Best Regards,
Rico Zhou

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

[ronaldg]

Hi @v-rzhou-msft 
Actually, have another step to do, I have another table(Completed Learning Report). Once I identified what's applicable learning to me. I want to check if learnings in learnings table are present in the completed learning report. If not, then I want to display those learnings that are not present in both tables or not yet completed.


Can you help me with this?

[ronaldg]

Exactly what I need, Thanks @v-rzhou-msft .

[lbendlin]

Please read about Row Level Security.  And about the difference between a dashboard and a report.