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

D365 Roles to be applied to Power BI report data

Let say 5 Power BI Reports generated with data Power BI dataset ( which has the source D365 data), Organization wants to provide the business user access according to their D365 role and They should see the data with respect to their data. 

 

Lets Say Finance department users should see the Finance related data rather than other departments data. How can it be achevied. 

with D365 role integrating with Power BI.

 

Note:  Not interested to create row level security option

1 ACCEPTED SOLUTION
djurecicK2
Memorable Member
Memorable Member

Hi @wsivasankar ,

 The situation you describe is what row-level security is designed for...

 

Without that, I suppose you could create a workspace for each department and only publish that department's data to their workspace, then give that department's users access to the workspace or app.


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

View solution in original post

1 REPLY 1
djurecicK2
Memorable Member
Memorable Member

Hi @wsivasankar ,

 The situation you describe is what row-level security is designed for...

 

Without that, I suppose you could create a workspace for each department and only publish that department's data to their workspace, then give that department's users access to the workspace or app.


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

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.