cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MarcoNeukom Frequent Visitor
Frequent Visitor

How to distribute multiple reports to salesmen

I have a report template which I use to multiple salesmen showing quantity sold, avg. prices and so on, just changing the name in the filter.

What is the best way to "control" all these reports? They are not allowed to see each other's report, but I don't want seperate workspaces for each salesman. 
Would be nice to have just one workspace holding a lot of individual reports where the salesmen are only allowed to see their own. 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: How to distribute multiple reports to salesmen

For ssas live connection you have to setup RLS in analysis services and not in power bi. Follow this article. https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-tutorial-row-level-security-onprem...


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


5 REPLIES 5
Super User
Super User

Re: How to distribute multiple reports to salesmen

Use Row Level Security (RLS). One report, create a role for each sales person, assign each sales person to their roll and you are done.


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


Highlighted
MarcoNeukom Frequent Visitor
Frequent Visitor

Re: How to distribute multiple reports to salesmen

Hi @Greg_Deckler

The modelling tab is not available to me as I am using and OLAP cube connection. 

Any solution to this? 

Super User
Super User

Re: How to distribute multiple reports to salesmen

You are using DirectQuery?


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


MarcoNeukom Frequent Visitor
Frequent Visitor

Re: How to distribute multiple reports to salesmen

Yes. Hopefull soon a tabular model, but for now I am stuck with DirectQ and olap cube connection

EDIT* sorry I am using a live connection! 

Super User
Super User

Re: How to distribute multiple reports to salesmen

For ssas live connection you have to setup RLS in analysis services and not in power bi. Follow this article. https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-tutorial-row-level-security-onprem...


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!