Report to automatically drill based on user logged in

[Sai_Alkesh]

Hi,

I have a dashboard and have enabled RLS on it. The landing page has summary information and the user based on RLS, gets to see only their relevant area (region) data. Some of the visuals have drill down, so that user restricted to particular region, can drill further down to their countries.

Is it possible, that when the restricted user accesses the Sharepoint, the landing page will automatically expand (drill down) on the visual which will show them their countries, and they do not have to click on drill button.

Appreciate your help !

Thank you.

[v-lili6-msft]

hi  @Sai_Alkesh 

To my knowledge, it couldn't achieve in power bi for now.

and you could keep the visual is in the Drill location you want, then with RLS it will meet your requirement.

https://powerbi.microsoft.com/en-us/blog/announcing-persistent-filters-in-the-service/

Regards,

Lin

[Sai_Alkesh]

Thank you for this @v-lili6-msft , but this isnt working for me when i have the report securely embedded in Sharepoint online.

Is there a way to enable this ?

Regards,

[v-lili6-msft · Accepted solution]

hi  @Sai_Alkesh 

To my knowledge, there is no way to achieve your requirement for now.

Regards,

Lin

[Greg_Deckler]

I'm not aware of any way to do that.