Reply
Highlighted
Member
Posts: 89
Registered: ‎12-02-2015
Accepted Solution

Limit users ability to view reports - dashboard access only

Within our organisation I have created various dashboards and given relevant users access to certain dashboards, not everyone has access to all of them. I thought this was all working well however I have just discovered that by clicking on any visual in the dashbaord the user gets access to EVERY page and visual in my report(!). 

No, I will first of admit that this has been caused by a lack of thorough due dilligence by me however I am quite suprised. 

Is there anyway that I can limit this. Once I have provided people with dashboards I only want them to view report pages containing those visuals, or even more drastically, not allow them to view the report at all.

On a side note, how would I create multiple reports without having to rebuild my entire data set for each report? Currently I have one data set which is linked to a single PBX file.  I make import all my data via this, create measures, make visuals etc and then publish to PowerBI in a report (and dataset) called "Company Data". 

Is there a way I can create multiple reports without having to build a wholoe new data set each time which would be a mess to maintain. 

Thanks. 


Accepted Solutions
Super Contributor
Posts: 1,661
Registered: ‎12-15-2015

Re: Limit users ability to view reports - dashboard access only

@maracles By design when you share a dashboard regardless of whether you had one pinned visual on it or pinned live page, user you've shared with gets access to same dashboard, reports and data as yourself including all the reports that you have within that pbix.

 

 

In order to use single dataset for multiple reports, once your dataset is published from powerbi desktop to powerbi service, in powerbi.com under Datasets click open on your dataset -> create visuals as required -> file -> save as. This will create a new report using single dataset.

View solution in original post


All Replies
Super Contributor
Posts: 1,661
Registered: ‎12-15-2015

Re: Limit users ability to view reports - dashboard access only

@maracles By design when you share a dashboard regardless of whether you had one pinned visual on it or pinned live page, user you've shared with gets access to same dashboard, reports and data as yourself including all the reports that you have within that pbix.

 

 

In order to use single dataset for multiple reports, once your dataset is published from powerbi desktop to powerbi service, in powerbi.com under Datasets click open on your dataset -> create visuals as required -> file -> save as. This will create a new report using single dataset.

Member
Posts: 89
Registered: ‎12-02-2015

Re: Limit users ability to view reports - dashboard access only

@ankitpatira Thanks for your response. I've had a look and that is what I will have to do, although it would nice to do this from within the PBX file itself.

Also, it feels like this is going to make maintenance and management of reports a little more complicated!

Member
Posts: 142
Registered: ‎01-10-2016

Re: Limit users ability to view reports - dashboard access only

@maracles are your shared dashboard visuals pinned to dashboard, or a whole report pinned live? 

 

in scenario 1, navigate to the dashboard --> click open menu "...." --> tile detail --> set a custom link (could be any website) in this case when any user press the visual in the dashboard, it will redirect them to the custom link

 

in scenario 2, if you have pinned a live page (personally I love this option, as it gives the same awesome interactivity function of a report) --> go to tile detail --> untick the first box "title and subtitle" now your users won't be able to drill down to the report, and they still can use the functionality of a report inside a dashboard.

 

I created 46 pages in a report, each for a sales user, to maintain data protection 

 

 

 

 

Member
Posts: 89
Registered: ‎12-02-2015

Re: Limit users ability to view reports - dashboard access only

@majdkaid22 Thanks for those suggestions. Both could come in useful but the second one especially. 

Frequent Visitor
Posts: 6
Registered: ‎08-26-2016

Re: Limit users ability to view reports - dashboard access only

Hello,

I'm trying to do something similar, but ran into an issue with testing out "scenario 2".  When the dashboard is shared with someone, they can't click through to the whole report; however, they can click "..." in the corner, then click "go to report", and in that way access all pages and the entire report.

 

Does anyone have a solution that gets around this, and completely prevents the end user from accessing the entire report?

 

Thanks!

Frequent Visitor
Posts: 2
Registered: ‎12-16-2016

Re: Limit users ability to view reports - dashboard access only

I have the same problem. User can click "..." in the right corner, then click "go to report" and view all pages and reports.

 

I only want users to view the reports on Dashboard.

 

Is there any way to do?

 

Thanks!

Occasional Visitor
Posts: 1
Registered: ‎03-09-2017

Re: Limit users ability to view reports - dashboard access only

Do we have any update on this? Is there any way users can only access the pages related to the pinned dashboard page and not the entire report? Say, a report has 5 pages from which I pinned 4 pages in a single dashboard. When users click on "..." and go to report, they get to access all 5 pages instead of just 4. 

Visitor
Posts: 1
Registered: ‎03-20-2017

Re: Limit users ability to view reports - dashboard access only

Hello Everybody,

 

I am struggeling with the exact same thing. In our organisation we have 20 reports that need to be shared within our companies o365 enviroment.  The reports need to be restricted to different users. I tried above scenario 2, but ran into same porblem that users can actually see the reports not intended for them by clicking on the three dots in the upper left corner of the tile. Row level security is not a solution for us because data from the Data Ware House build for this project goes from different fact tables to the visuals. It is the visuals that should be resticted. RLS would be complex to set up & resulting in empty visuals in pages with 5-6 filters doing nothing.

Is it true that i really need to make a single PBIX file for every different user in order to achieve restricted access to reports? This would mean 6 different files and changes to reports included in different files should be made 6 times?

 

Thanks!

Frequent Visitor
Posts: 2
Registered: ‎09-20-2017

Re: Limit users ability to view reports - dashboard access only

[ Edited ]

using scenario 2, disable the heading on the dashboard.

. Getting automatic access to the report seems ridiculous and thankfully I discovered it just in time. otherwise what is purpose of creating user based dashboards when each user could access the whole report. 

 

however, seems users can still access the whole report, particulary using the application on a tablet.