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.
Hi all,
For my current employer I'm working on creating a dashboard. For this we have 7 clusters that all need individual dashboard. Alot of people are going to see these, therefore I don't want them to have to use the filter pane too much. And definitely not use the online Paramenters. All with all I need 7 different dashboard, however I want, as a developer to only have to create 1 dashboard that I can maintain. So any changes to 1 cluster will immediately also been seen in the other 7.
My data is coming from a SQL server where I have 1 database with 7 tables, 1 per cluster.
I was wondering what was the most efficient way of making this work. I started by loading the full data into the desktop and with parameteres filter down the report to a cluster. However if I upload this to the online service, I will need to do this 7 times. Save the report in a different name and do that again..
Any advice?
Thanks alot, Jeroen
Solved! Go to Solution.
@Anonymous here are few links for you
http://radacad.com/row-level-security-configuration-in-power-bi-desktop
https://blog.tallan.com/2018/04/10/row-level-security-in-power-bi-part-1-roles-and-users/
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.
@Anonymous you can use RLS (Row level security) so that one report can be used across all 7 clusters and each user get to see their own cluster. I think that is what you are looking for. There are lot of videos/blog to implement RLS, if you still need further help, let me know
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.
Thanks alot! Sounds like a good idea.. I do not have any experience with implementing RLS. Do you have any recommedations?
@Anonymous here are few links for you
http://radacad.com/row-level-security-configuration-in-power-bi-desktop
https://blog.tallan.com/2018/04/10/row-level-security-in-power-bi-part-1-roles-and-users/
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 |
---|---|
112 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
108 | |
90 | |
64 |