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

Same Visualizations, Different Data, For Every User

I'm not sure if this post is in the right place (as it is a question about Power BI in general I think).

 

Is it possible to have one set of visualizations on a web app that every user is able to use/see, but the actual data that populates them will be specific to the user? i.e. same graphs, different data, for everyone. Thanks.

4 REPLIES 4
Super User
Super User

Re: Same Visualizations, Different Data, For Every User

Are you talking about internal or external users?

 

We have SSAS and roles on the cube, when user access these graph, it shows different data depends on their roles/permission on the cube.

 

Also check out RLS (Row Level Security) https://powerbi.microsoft.com/en-us/documentation/powerbi-admin-rls/






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

Proud to be a Datanaut! Appreciate your Kudos Smiley Happy
Feel free to email me with any of your BI needs.





bobby97 Frequent Visitor
Frequent Visitor

Re: Same Visualizations, Different Data, For Every User

External users. So I build the web app that hosts the Power BI visualizations/graphs (through Embedded or maybe something else?), and then import the data by user. The data would then be used to populate the visualizations/graphs.

 

Thanks for the response. I'm not familiar with SSAS, but would that allow external users to be invovled?

Super User
Super User

Re: Same Visualizations, Different Data, For Every User

Thanks for clarifying that you are using embedded, I worked briefly on it and worked great. Here is LINK for more information on RLS in Embedded.

 

Curious, what is your data source? 






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

Proud to be a Datanaut! Appreciate your Kudos Smiley Happy
Feel free to email me with any of your BI needs.





Moderator v-sihou-msft
Moderator

Re: Same Visualizations, Different Data, For Every User

@bobby97

 

You don't have to get a SSAS data source. I assume you already have a UserInfo table.

 

125.PNG

 

You just need to create a role and add row level filter based on USERNAME().

 

123.PNG

 

Then add those users in Row Level Security.

 

124.PNG

 

Regards,

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 117 members 1,853 guests
Please welcome our newest community members: