how to limit the access of power bi dashboard

[Anonymous]

Hello All, I have created a testing role from desktop manage roles. After I published this dashboard, What I know is go to the secury to test it. It works.

What about the testing role , if he loginto the share point dashboard, does he need to go to secury and test? I don't understand what happen next.

I would like to use a column that dynamically restrict the access, for example , if user login to the sharepoint, it will only show the data from his department. 

Sorry this is a broader question, any suggesetion or learning materials related to this will be very appreicated. 

[v-frfei-msft · Accepted solution]

Hi @Anonymous ,

Username() returned the UPN of the user using the report. Before that, we should have a UPN list in our data model. Please refer to the online document.

https://powerbi.microsoft.com/en-us/blog/using-username-in-dax-with-row-level-security/

If it doesn't meet your requirement,  kindly share your sample data to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.

[Mariusz]

Hi @Anonymous 

Try these articles

https://docs.microsoft.com/en-us/power-bi/service-embed-report-spo

https://community.powerbi.com/t5/Community-Blog/Dynamic-Row-Level-Security-Dynamic-RLS/ba-p/787399

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[Anonymous]

@Mariusz Thanks for sharing the links. I followed the second link. and created a dynamic role based the column NTUSER I have. It is not an email infor, something like this below:

NTUSER

VTD001

VTD003

VTD004

VTD005

...

However, When I go back to the view as , use VTD001, all dashboards show blank.. 

Any clue.. thank you