Forum Discussion
Drill through based on User Logged In
Hello rohit1991 , danextian , v-aatheeque , lbendlin , pbiuseruk
appologize for late responce.
1. Conditional Visibility on buttons (or any other visuals in PBI) will NOT work because this feature is not available at the moment in PBI. I searched for this option but not available.This Conditional Visibility on any visul is a good to have feature but PBI dont have it 😠correct me if am wrong!
2. Duplicating same report for diff users is not a viable option.
I achieved Conditional Drill through by creating User Access table (with user email and access true or fales) and 2 measure (one is identifying the user is authorized or unauthorized. and second is based on the access assigning the respective pages).
Hi PremK ,
Drill-through in Power BI can’t filter automatically by the logged-in user, since drill-through only works on model columns and not user identity or RLS. What works best is to add a User Access table that lists emails and access levels, then use a DAX measure with USERPRINCIPALNAME() to check who’s logged in.
You can then set up separate drill-through buttons (or links) and control which one is visible for each user using that measure. This way, users only see the drill-through option that matches their access level. It’s not fully automatic with a single button, but this method keeps everything in one report without messy duplication.
Hello rohit1991 , danextian , v-aatheeque , lbendlin , pbiuseruk
appologize for late responce.
1. Conditional Visibility on buttons (or any other visuals in PBI) will NOT work because this feature is not available at the moment in PBI. I searched for this option but not available.This Conditional Visibility on any visul is a good to have feature but PBI dont have it 😠correct me if am wrong!
2. Duplicating same report for diff users is not a viable option.
I achieved Conditional Drill through by creating User Access table (with user email and access true or fales) and 2 measure (one is identifying the user is authorized or unauthorized. and second is based on the access assigning the respective pages).