Forum Discussion
Change filter using URL
Hello!
I have a shared dashboard and report in powerbi.com. It's shared to more than 30 people
The report has some filters (slicers) like "date", "companyName", "owner"... and nobody wants to see info from others, they want to see always his rows without click in all the filters. There is any chance to use the original URL + some parameters, or using API rest or somethign like that to customize the filters?
12 Replies
Hi 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 GuHello,
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.
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
