Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Prabha45
Helper III
Helper III

Data based user login (without RLS)

Hi Everyone,

I have a table ( Table1 ) like below and I have 3 slicers Proposed, Developed, Approved.
I need to show complete data when any user looged in, but when he clicks on Approver he needs to see only the data where he is in Proposed.
Ex- If Kevin logged in, he will see the complete data(Table 1), when he clicks on Proposed slicer he needs to see only Project1 and Project 3 where he Proposed ( Table 2 )
Table 1 - 

DomainProjectProposedDevelopedApproverStatus
Domain1Project 1KevinMarkJohnCompleted
Domain 1Project 2NickKevinStevinIn progress
Domain2Project 3KevinStevinMarcusDraft
Domain2Project 4JohnNickStevinOverdue
Domain3Project 5MarcusStevinKevinCompleted
Domain3Project 6MarkKevinKevinDraft

 

Table 2 -

DomainProjectProposedDevelopedApproverStatus
Domain1Project 1KevinMarkJohnCompleted
Domain2Project 3KevinStevinMarcusDraft
0 REPLIES 0

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.