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 there,
Is it possible to share a report via open link (without the tenant, visible to all to be clear),
With fixed filters and without the possibility to edit filters?
There are about 10 clients on my report,
I just want to share their own report fixing client filter
Thank you in advance for the response,
Diego
Solved! Go to Solution.
For your use case, Row-Level Security (RLS) seems to be the solution. It is used to make only the data available to user as veiwable to them.
Refrence Link: https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls
Give a thumbs up if this post helped you in any way and mark this post as solution if it solved your query !!!
Hi @dgianni ,
You can clear "persistent filtering" and "hide filter panel" before publishing and sharing to user.
Clearing persistent filters will allow user to change filters but will not the changes will not be saved in services.
Hiding filter panel will not give user the ability to change visual/page filters.
If you are taking about in-canvas slicer filtering, i don't think you can have something to not allow user to change it unless you give only your selected element as option.
Give a thumbs up if this post helped you in any way and mark this post as solution if it solved your query !!!
Can you please show me how to do it?
Thank you 🙂
For persistent filter:
File -> Options and Settings -> Options ->Current File: Report Settings (Last option in left pane) -> Tick the first checkbox
For hiding Filter Pane:
Click on View -> Click on Filter in "Show Panes" section (It should not have grey background)
Give a thumbs up if this post helped you in any way and mark this post as solution if it solved your query !!!
Thank you for the response,
As "Filter" i was mistakenly talking about the graphic object that i use as filter,
In background i have many more filters not editable by the user.
As i want to send the report to any of my clients (each green line is a client), but at the same time i don't want that a client see the stats of another one,
How can i fix the "Tipo | Linea Corriere"?
Is there a way to make it not editable by the user in a free link report (not on tenant)?
Thank you 🙂
Hello @dgianni
We can implement RLS on the report which will help you to achieve your desired goal !!!
What is RLS?
https://www.youtube.com/watch?v=MxU_FYSSnYU
Video on how to implement RLS
https://www.youtube.com/watch?v=9wN33rTaiB4
RLS can be confusing in terms of Dynamic and Static!
Dynamic - you can implement it when you have a column with email id associated with the customers.
How to implement Dynamic RLS?
https://www.youtube.com/watch?v=iMfkj_xgYYc
https://www.youtube.com/watch?v=TGgec9oP8oU
How to implement Static RLS?
https://www.youtube.com/watch?v=4DjXDKbF02k
IF YOU LIKE MY SOLUTION PLEASE GIVE A KUDOS 👍
AND IF IT SOLVES YOUR PROBLEM ACCEPT IT AS A SOLUTION
For your use case, Row-Level Security (RLS) seems to be the solution. It is used to make only the data available to user as veiwable to them.
Refrence Link: https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls
Give a thumbs up if this post helped you in any way and mark this post as solution if it solved your query !!!
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.