Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I want to develop a report in which the filter should only display the currency in which the employee has done transaction in i have a table shown
natural currency key -is the curreny id
how should i approch in order to achive the output?
NaturalCurrencyKey SalesID SalesTerritoryName EmployeeID CurrencyCode
120 9999 Australia 12 CHF
117 1111 india 12 SEK
output requried :- when employee id 12 is using the report he should only see the currency filter as CHF and SEK
no other currency which we have in the table
@aka,
For your requirement, each employee should only see the currency in which the employee has done transaction, we can use Row-level security to achieve it.
In Power BI, Row-level security (RLS) can be used to restrict data access for given users. Please refer to the link below to see how to set up RLS for your report.
https://powerbi.microsoft.com/en-us/documentation/powerbi-admin-rls/
Regards,
Charlie Liao
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
97 | |
95 | |
68 | |
65 |