Reply
navin_Learning
Frequent Visitor

User Logged IN data filtration in Paginated Report without relationship

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

PolicyCode 1Code 2Sum
1234100102000
5678100102000
91011100203000
121314101304000
151617101305000
15161813375600
15161713375800
151615144529000
151617144521222

 

Dataset 2

UserCode 1Code 2
abc@xyz.com10010
def@xyz.com10010
pqr@xyz.com10020
mno@xyz.com10130
mnt@xyz.com10130

 

Thank you for any help!

 

Best Regards,

Navin

0 REPLIES 0
avatar user

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)