Forum Discussion
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/
- bobby979 years agoNew Member
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?
- v-sihou-msft9 years agoMicrosoft Employee
You don't have to get a SSAS data source. I assume you already have a UserInfo table.
You just need to create a role and add row level filter based on USERNAME().
Then add those users in Row Level Security.
Regards,