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