Forum Discussion
Filtering report based on username viewing it
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