Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Ashrafh
New Member

Send powerBI report to the manager

Hi,

I have a PowerBI dataset where user enrolment status is shown along with the manager name of the user.

Meaning multiple manager and user names are on the list. Now if i want to send a report to the manager of a particular user rather than sending the whole dataset to each manager ... how can i do that? 

Is it even possible to filter the dataset using manager field on the go?

I prefer to use MS Flow for this.

 

Any help would be appreciated. Thanks

 

Ashraf

2 REPLIES 2
v-juanli-msft
Community Support
Community Support

Hi @Ashrafh

Based on my knowledge, blopez11's suggestion should be helpful.

Besides these, i would suggest:

1.you should have a table where each employee only has their direct manager’s ID associated with employees' email address or employee id, for example

3.png

2. you also need manager information table which shows the manager id, name and email,

3.then create relationship in Power BI Desktop, relate the employee data table with manager information table.

4.implement dynamic RLS in the manager information table, so that every manager log in Power BI Desktop or Service, he would only see data of  employees who belong to his own department.

for dynamic RLS, besides blopez11's links, links below may also helps:

https://community.powerbi.com/t5/Integrations-with-Files-and/present-the-data-in-report-according-to...

Dynamic Row Level Security with Manager Level Access in Power BI

 

Best Regards

Maggie

 

blopez11
Resident Rockstar
Resident Rockstar

Yes to your second question

This can be done by implementing dynamic row level security into a single report, then share that one report with your managers

Depending on how you implement your model, they will only see data where they are the manager

 

You can take a look at the following articles for reference, as they helped me

https://docs.microsoft.com/en-us/power-bi/service-admin-rls

https://blog.tallan.com/2018/04/10/row-level-security-in-power-bi-part-1-roles-and-users/

 

I would rather implement dyanmic row level security in a single report, than having separate reports per manager

 

Good luck

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors