Same Visualizations, Different Data, For Every User

Question

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.

parry2k · Answer

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/

bobby97 · Answer

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?

parry2k · Answer

Thanks for clarifying that you are using embedded, I worked briefly on it and worked great. Here is LINK&nbsp;for more information on RLS in Embedded.&nbsp;Curious, what is your data source?&nbsp;

v-sihou-msft · Answer

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

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

&nbsp;
Then add those users in Row Level Security.
&nbsp;

&nbsp;
Regards,

Forum Discussion

Same Visualizations, Different Data, For Every User

4 Replies

Related content

Visualizing Historical Data

Aligning Data With different dates

Error fetching data for this visual

imported data not refreshshing in visuals

Map visual differences