Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
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
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.