Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I am working on a report that will used to visualize a large amount of data for over 100 distinct customers via DirectQuery/SQL. There is far too much data to use typical RLS to enforce filtering so each customer see's only their own data.
Is there any way I can use the report viewer's role, email or username as a query parameter? Or any other indirect way I could relate that information to my queries?
I am aware of the DAX expressions USERPRINCIPALNAME() and USERNAME() but they can only be used after the DirectQuery Queries are complete.
Thanks,
Hi @Timsonater ,
I'm afraid that there is no other suitable method to achieve your requirement except the dynamic RLS...
Row-level security (RLS) with Power BI
Power Bi: Row Level Security using User Principal Name ()
Or you can raise a similar idea with the following one and add your comments there to make this feature coming sooner.
Assign USERNAME () to parameter of a SQL function data source
Best Regards
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |