Have you resolved your issue? If you have, please mark the helpful or right reply as answer. So that more people will benefit from here.
@sebbyp First, the external user will need a Pro license, and you will too.
What you can do is pin the visuals from the report to the dashboard. On "Each" tile, you need to click on the "..." in the upper right and select the pencil icon for "tile details", then under "Functionality" check the "Set custom link". Then make sure that the "Link Type" is set to "External Link". Scroll down and the URL value field will be enabled. You can take the URL of the dashboard and input it there. Under "Open custom link in hte same tab" -> set to "Yes"
When the end user clicks on the tile the page will appear to refresh but won't go anywhere. In this manner, you can restrict access to the underlying reports. However, if your dataset supports Q&A, the user would have access to interrogate your dataset by asking questions, so be aware of that.
@Seth_C_BauerMy dashboards are mainly filled with pinned live pages and the custom link functionality is greyed out. This is an issue i believe with your work around?
@sebbyp Correct. But now I'm confused. You are in essence, already showing them the report page. This is the exact same view they would have if you shared the dashboard and they drilled down. They only get "read only" they can't see your model, calculations, dataset, etc... they can only see what you show them and the filters.
@Seth_C_Bauerthats true but here's the problem i have. I have a report which has a different tab for each country we are analysing. The dashboards focus on a specific country and i want to limit the sharing to just this country specific dasboard as the information for other countries is sensitive.
If the user gets access to the whole report they can then see the other country tabs.
Does that make sense?
@sebbyp Yep, makes sense. I'm not aware of any way within the Service to do this. You'll have to break out the reports to only show the single tab they can see... This falls under RLS for tabs idea, the idea can be voted up here
@Seth_C_Bauerok thanks. I have done as you have suggested. Alternatively, just sharing the dashboard and nothing behind the dashboard would be the perfect solution. You would think it would be quite simple to do.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.