cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Cwboymn1
New Member

Dynamics 365 Dashboard with row level security

I am trying to use a report that I created Power BI that uses row level security and it works perfectly in Power BI as it should but when I bring that report into Microsoft Dynamics on a dashbord it loses the windows live id and shows all the data for all the users. has anyone figured a way to make it work or can offer some alteritive way to make it work?  

3 REPLIES 3
Community Support
Community Support

Re: Dynamics 365 Dashboard with row level security

Hi @Cwboymn1  ,

 

Did you add members to the RLS? See more: https://docs.microsoft.com/en-us/power-bi/service-admin-rls#manage-security-on-your-model.

 

rls-security.png

 

 

 

 

 

 

 

 

 

Did you run "Test as role" to see the RLS effect? RLS wouldn't work on the owner of the dataset. Because the owner can edit both the dataset and reports. RLS aims at controlling the data access rather than something like filtering. .

 

Using RLS with Dynamics CRM Online 2.jpg

 

 

 

 

 

 

 

 

 

 

 

 

In addition, if you publish your Power BI Desktop report to an app workspace within the Power BI service, the roles will be applied to read-only members.

 

If you have configured the app workspace so that members have edit permissions, the RLS roles will not be applied to them. Users will be able to see all of the data. See:https://docs.microsoft.com/en-us/power-bi/service-admin-rls#using-rls-with-app-workspaces-in-power-b....

 

Best Regards,

Amy

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Highlighted
Cwboymn1
New Member

Re: Dynamics 365 Dashboard with row level security

Yes, like i said everything works in Power Bi but once I atache the report to Dynamics it quites working 

Cwboymn1
New Member

Re: Dynamics 365 Dashboard with row level security

here you can see in power bi the correct user gage1.png

 

and once added to dynamics

 Gage2.png

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors