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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
teemutee
Frequent Visitor

Filtering report based on username viewing it

I need to show personal reports embedded on Sharepoint, depending on user account that is viewing it. I don't mean general access groups (as in RLS), but that for every single user the report if filtered by their user name.

 

For example, userID 12345 has logged on to Sharepoint, and he goes to see report, and the report is automatically filtered by userID = 12345.

1 ACCEPTED SOLUTION
Salfii
Helper I
Helper I

Hi,

 

you can open a report with a (pre-)filter in the URL:

 

https://powerbi.microsoft.com/de-de/blog/filter-a-report-with-a-url-query-string-parameter/

 

Please note:

This filter is not fixed, the user can delte this filter criteria like any other filter.

 

I´m using this for example to open a prefiltered report directly from Dynamics CRM365 on button-press, based on the opened entity and the corresponding id, and it works great!

View solution in original post

2 REPLIES 2
abhip93
Regular Visitor

Hey,

 

I am also dealing with similar problem but instead of User account , I am generating a unique ID (for certain selection in UI , Where I have embedded the report)  for every user who are viewing report, In Database Table connected to Power BI I am appending rows to the exisiting table according to selections made in UI through SQL with a unique ID in ID column. Now I want to customize my report based on only those rows which satisfy the selection or the unique ID generated for that instance. 

Please anyone help me with this.

 

Thanks and Regards,

Abhigyan

Salfii
Helper I
Helper I

Hi,

 

you can open a report with a (pre-)filter in the URL:

 

https://powerbi.microsoft.com/de-de/blog/filter-a-report-with-a-url-query-string-parameter/

 

Please note:

This filter is not fixed, the user can delte this filter criteria like any other filter.

 

I´m using this for example to open a prefiltered report directly from Dynamics CRM365 on button-press, based on the opened entity and the corresponding id, and it works great!

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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

Top Solution Authors
Top Kudoed Authors