Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Dear All,
I have a report published in Workspace, and am using the dataset to create a paginated report, the report has to many columns (thats a totally different challenge though).
What i want is, when this paginated report is published in a workspace and when a user logged in to see/print the report, he should only see data relevant to him. For this i need help with 2 question.
1. How do i filter data with logged in user
2. The main data doesn't contain user information, the link between main data and user data is two column having code information, residing in 2 different column (Code 1 & code 2), so how does i link this, and satisfy the condition with both parameters.
Dataset 1 - Main data (includes code 1 & code 2 column)
Dataset 2 - User data (contains UserID and code 1/ code2 column)
Dataset 1
Policy | Code 1 | Code 2 | Sum |
1234 | 100 | 10 | 2000 |
5678 | 100 | 10 | 2000 |
91011 | 100 | 20 | 3000 |
121314 | 101 | 30 | 4000 |
151617 | 101 | 30 | 5000 |
151618 | 133 | 75 | 600 |
151617 | 133 | 75 | 800 |
151615 | 144 | 52 | 9000 |
151617 | 144 | 52 | 1222 |
Dataset 2
User | Code 1 | Code 2 |
abc@xyz.com | 100 | 10 |
def@xyz.com | 100 | 10 |
pqr@xyz.com | 100 | 20 |
mno@xyz.com | 101 | 30 |
mnt@xyz.com | 101 | 30 |
Thank you for any help!
Best Regards,
Navin