Forum Discussion
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.
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
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!
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!
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.
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!
