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
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!
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.