cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
gaiusgw
Helper I
Helper I

Sharing report with multiple people with their own view

I have 8 people on my sales team. I have one report. I need to be able to share it with each of the 8 with filters that narrow down what they see to their own rep code. From I understand, I cannot share just tabs from my report which would be the simpliest option because I could create dupliates of tabs with the filters needed for each one. And if I create 8 different versions of the report, 8 versions will be importing the same dataset everyday which is just redundent. I am looking for an elegant solution to share a filtered version of one report to each of the 8 sales reps. Any suggestions? 

1 ACCEPTED SOLUTION
gaiusgw
Helper I
Helper I

So RLS actually has a few handicaps as a solution because there are tabs where I do actually need them to see info from other regions. But fortunately, I found a solution on another thread. 

 

https://community.powerbi.com/t5/Desktop/Duplicate-report-using-the-same-Dataset/td-p/355890

 

This is the solution that did the trick for me:

 

"Created a copy of the Power BI file giving it the name of the new report, so now I have a duplicate with all my data and visuals.

 

Deleted all the tables and queries from the report.  All the visuals still there but obviously all broken now as there's no data.

 

Get data from the BI Service and select the same dataset the report was originally based on and hey presto all the visuals work again.

 

Now when I publish to the service it's only a report and will stay connected to the original dataset so no duplicate data to refresh."

 

Credit to user @robofski 

 

With this persons solution, you can have multiple reports share the same dataset. It does take a little reconstructing but this did the trick for me. Now I have 8 pbix report files that I can filter lock for each rep and these reports share one dataset so there is no redundant datasets. 

 

Thanks for your brainstirming guys! 

View solution in original post

5 REPLIES 5
gaiusgw
Helper I
Helper I

So RLS actually has a few handicaps as a solution because there are tabs where I do actually need them to see info from other regions. But fortunately, I found a solution on another thread. 

 

https://community.powerbi.com/t5/Desktop/Duplicate-report-using-the-same-Dataset/td-p/355890

 

This is the solution that did the trick for me:

 

"Created a copy of the Power BI file giving it the name of the new report, so now I have a duplicate with all my data and visuals.

 

Deleted all the tables and queries from the report.  All the visuals still there but obviously all broken now as there's no data.

 

Get data from the BI Service and select the same dataset the report was originally based on and hey presto all the visuals work again.

 

Now when I publish to the service it's only a report and will stay connected to the original dataset so no duplicate data to refresh."

 

Credit to user @robofski 

 

With this persons solution, you can have multiple reports share the same dataset. It does take a little reconstructing but this did the trick for me. Now I have 8 pbix report files that I can filter lock for each rep and these reports share one dataset so there is no redundant datasets. 

 

Thanks for your brainstirming guys! 

View solution in original post

AbhiSSRS
Responsive Resident
Responsive Resident

If I am not missing anything here, this is a typical RLS scenario. Please let know if you need any help setting up RLS. The below link has it.

 

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

 

lbendlin
Super User III
Super User III

You didn't specify that.  In that case you will want to think about using RLS.  

From my experience though RLS is the wrong answer in this scenario.  Sharing sales numbers across sales people will aid in their competitiveness.  (Of course comp is an entirely different story - there RLS is a must)

lbendlin
Super User III
Super User III

Teach them how to set their own filters, how to create bookmarks, and how to call these bookmarks up again.


@lbendlin wrote:

Teach them how to set their own filters, how to create bookmarks, and how to call these bookmarks up again.


The problem is I don't want them to see each other's information. So what I wanted to do was set the filter, lock it and then share with each of them to prevent them from having visibility of each other. 

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors