Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
i have a power bi visual with table and slicers in it. I would like to share these data on web (i know how)... but with filtered data only to that user
... and than share the same visual to another user but with filtered data again only to that user.
For example, this table have column "Name of Sales" with the same slicer. And I want to share to Tom only the values with "Tom" in that column so he cant see his colleagues data.
Is that possible?
Thx
Solved! Go to Solution.
So you are using the App to share it,
In this case you need to setup the RLS that makes use of the username and returns only the information for that specific user.
Have you took a look into the link I have shared in the previous post?
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @mskarka,
For this you need to use the filter on the URL:
https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters
This allows for you to send a filter value added to your URL of your report.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em Portuguêsif I filter it in url, than they can change it... right?
I need to filter them data so they cant see or change the view... but also have it simple so I do not have 20 copies for 20 colleagues and than change 20 copies 20 times if I want to add something
They can change it but they need to know the other names.
Sharing trough URL (and be aware that this in not secure way) there is no workaround to my knowledge. if you were using the service you could use RLS to give you the expect result.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsThis does not sound secure (they know the names). What do you mean by RLS?
Hi @mskarka ,
Just to clarify one thing, when you refer that you are " I would like to share these data on web (i know how)... " what exactly do you mean? Are you creating a public link? Sharing irt trough power bi service?
Regarding your question RLS is row level security and this can be applied to a dataset in several ways so that the users when they enter the service they will only see the data that they are allowed, meaning that if Tim enters he would only see his own data and nothing more.
https://learn.microsoft.com/en-us/power-bi/enterprise/service-admin-rls
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHello and thx for your help
I am sharing the data like this for specific users in our company:
And, each user should see only their data, but the same visual (because I might need to change it in future...)
So you are using the App to share it,
In this case you need to setup the RLS that makes use of the username and returns only the information for that specific user.
Have you took a look into the link I have shared in the previous post?
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsNow i did!! thatt looks like exactly what I need. Will explore that more. Thank you very much.
Hello @mskarka ,
You could duplicate the page and set the filters in the two different pages, thus he could see these two versions in seperate pages.
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Proud to be a Super User! | |
That sounds good, but what about future changes? If I duplicate page dor 10 users and than want to change that table visual... Do I have to change it 10x times than?
User | Count |
---|---|
96 | |
87 | |
78 | |
72 | |
68 |
User | Count |
---|---|
113 | |
105 | |
84 | |
65 | |
64 |