cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Regular Visitor

Share a report with an open link without the possibility to edit

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

1 ACCEPTED SOLUTION

@dgianni,

 

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 !!!

 

 

View solution in original post

6 REPLIES 6
Memorable Member
Memorable Member

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 🙂

@dgianni,

 

For persistent filter:

File -> Options and Settings -> Options ->Current File: Report Settings (Last option in left pane) -> Tick the first checkbox

 

persistent filters.PNG

 

For hiding Filter Pane:

Click on View -> Click on Filter in "Show Panes" section (It should not have grey background)

filter pane.PNG

 

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 🙂

 

IMG.jpg

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 

 

 

@dgianni,

 

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 !!!

 

 

View solution in original post

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors