Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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/
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
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?
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,
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?
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |