Forum Discussion
Advocate IIChange filter using URL
Microsoft EmployeeHi serargi,
Since we can filter a report with a URL query string parameter, but you should append different parameter values for differnt recipients to the URL, also, only a string compare is available using this syntax ?filter=<Table>/<Field> eq 'value'.
I think what you need is RLS. Row-level security (RLS) with Power BI Desktop can be used to restrict data access for given users. Filters restrict data at the row level. Once you have configured RLS in a report, the visual inside this report will keep the RLS settings after being pinned to dashboard and sharing dashboard to others.
Reference: Row-level security (RLS) with Power BI
Best regards,
Yuliana Gu
Advocate IIHello,
thanks for your support! Roles are fine but I think URL parameter fits better for the solution we need.
I tried using
https://app.powerbi.com/groups/me/reports/XXXXXXXXXXXXXXXXXXX/ReportSection3?filter=Users/Owner eq '[email protected]'
but it didn't work. Owner is a colum in Users Table, and Owner is string.
- v-yulgu-msft
Hi serargi,
Based on my test, above syntax is correct. In your scenario, please check whether you have configured proper relationship between Users Table and other tables which are referenced in visualizations.
Regards,
Yuliana Gu- serargi
Hello v-yulgu-msft,
I checked as u told me, and it has correct relationship, but it still not working :/
- v-yulgu-msft
Hi serargi,
Have you tried to republish the pbix file? If you filter data based on another table/column, does it work? Please note that table and field names are case sensitive.
Could you illustrate how you created the report with some sample data so that I can try to rerpoduce your scenario?
Regards,
Yuliana Gu