Locking down dashboards on a live connected Dashboard

[John_R]

I have a bit of a problem that I hope the community can assist me with.  We currently are publishing our dashboards via a Live connected SQL server to the power bi site.  When we shared the dashboard to another power bi user within our own organization, who has the same powerbi pro license, we noticed that they were able to see ALL data within a filter by clicking on the dots in the upper right hand corner of the dashboard and selecting "go to report."  

This is a concern because it allows them to see more data than we'd like them to see.

How can I remove the ability for those who have a valid login to see the report options, while allowing them to see their dashboard that we have created for them?

Any thoughts?

Thank you in advance.

JR

[v-qiuyu-msft]

Hi @John_R,

In fact, you can add many new tiles from a report. Each of these tiles, when clicked, is a link back into the report by default. You can set the custom link for the dashboard visual to the dashboard. See: Add a hyperlink to a dashboard tile.

Best Regards,
Qiuyun Yu

[John_R]

I appreciate you getting back to me on this issue. 

While that's definately something to consider, doesn't that introduce another potential security risk?  If you have an embedded URL, couldn't someone just copy the link out, email the link to a competitor, and that data all of the sudden becomes public?   That's definately something we are trying to avoid.  

Going back to the original issue, Is there a way to remove the filters completely from a shared and published dashboard?  This way we can share the dashboard, and the customer could interact with the dashboard, but not change any of the filters, limiting data exposure.

Please let me know your thoughts. 

[v-qiuyu-msft]

Hi @John_R,

Currently, it's not supported to hide the Filters pane from the report. You can vote on this same idea: Hide filters for shared Reports or prevent user from changing filters.

Meanwhile, as Filters pane not available in shared dashboard, you can customize link for the dashboard visuals to prevent end user entering original report mentioned in my previous post.

Best Regards,
Qiuyun Yu

[John_R]

Thank you for your response.  However, we do not see that option.  Is that because we are using a live connected database?

Please let me know.

[v-qiuyu-msft]

Hi @John_R,

You can set custom link for the dashboard visual like below:

Best Regards,
Qiuyun Yu

[John_R]

We do not see that option on our dashboards.  The set custom link and URL option are both greyed out.

[hundred_swan]

The custom link will be greyed out if you pin an entire report page as live tile (more than one tile) to the dashboard. The custom link is only availabe if you pin indivdual tile or visualization to the dashboard.

I am also waiting the solution of this problem because users can click the shared dashboard to view all data and reports.

The solution is very simple if dashboard has an option to hidden the Open Menu (three dots on the right top corner) and don't allow go to report.

Any solutions? Why other people don't have this problem?

[John_R]

A little more on this:

When we created the tiles as suggested with the Custom URL, we noticed that the tiles didn't change when you selected a single item within the tile itself, which is disappointing.  The ability to drill down into data "on the fly" and have all of the other items on the page change as you select items is something we are looking to accomplish.  Going to single tiles destroys this capability.

We also found out that, regardless of the customer URL, you are still able to get to the filters.   You can accomplish this by going into the "focus mode" within the tile itself.  By doing this, the filters apears in the right hand side of the screen.  

Has anyone run across a solution for this?

please let me know.