Forum Discussion
Dynamic web request on opening the report, use response as filter data
Hi lars_hei,
I think you can consider using row level security to achieve your requirement.
Row-level security (RLS) guidance in Power BI Desktop - Power BI | Microsoft Learn
You need to prepare a user table to mapping username with locations and use location as key to link other tables.
Then you can create a user role based on username/userprincipalname and use expression to get the current user location value and use this as condition to filter other table records based on relationship.
USERNAME, USEROBJECTID, USERPRINCIPALNAME, CUSTOMDATA, USERCULTURE – DAX Guide - SQLBI
Regards,
Xiaoxin Sheng
HI lars_hei,
Yes, my suggestion required your table inlcude relationship that can link user id and corresponding locations.
The username are used the find out user id and get the locations, then RLS filter should applied to the location field and applied this filter to different tables based on table relationships.Regards,
Xiaoxin Sheng
Hello Anonymous
thanks for your reply 🙂
So this means the request based approach is not possible, corret?
Our MS users in Entra already have a custom field which would identify the user with an ID we know,
and our user -> office table would contain this ID and the ID of the office.
No mapping should be required here, no?
Why do I need a user role or custom functions in this scenario?
HI lars_hei,
Yes, my suggestion required your table inlcude relationship that can link user id and corresponding locations.
The username are used the find out user id and get the locations, then RLS filter should applied to the location field and applied this filter to different tables based on table relationships.
Regards,
Xiaoxin Sheng