Forum Discussion
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.
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!
2 Replies
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!
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
