Question: If you’re using the Power BI Service, must all users interact with the exact same report, or could you separate your model into its own PBIX, and upload it into the service, then create multiple reports from that now-available dataset model, one per group that only includs the pages you’d like them to see?
Can you describe further how many different “scenarios” might be in play? Are there many commonalities between them? e.g., one dataset (data model), 3 PBIX reports each showing a number of different pages, etc.)
Possibly, but won’t pinning - say 4 of 10 visuals to a dashboard for the Manager - allow them access to the entire report if they click on the pinned visuals. Or am I missing something there - quite possible.
I came across this article when looking for a solution similar to what I believe you’re asking above. Ultimately it didn’t solve my problem, as the report and model i’d developed would need to have been completely rebuilt to achieve, however, thought you might like a read to see if this could help you.
I have similar situations - recently discovered this web article and it has really made a huge difference to how I think I will build out my model.
In this model you build your dataset in a PBIX file - call it master or golden dataset; then publish it to the service. You don’t create reports in it however. I think of it like the “enterprise” dataset with calcualted columns and measures that you are in control of etc.
Then in your circumstance you would open a new PBIX and create the report for yourself and the “Cell phone queen” - however your data source would be your golden dataset - see below for how to connect.
This report will connect to your golden dataset and have access to use all the content within (although it won’t show you the data view etc.)
Then publish it - because it is connected to the golden data set the publish will be rapid. Any future changes to the report visuals can be published very rapidly.
Your next report for other management - same process but containing what you want them to see.
That sounds like a lot of hard work but it’s not - creating the diff reports for different users will be super quick as you’re connecting to your master dataset each time (which you know etc).
Down the line if you want another measure for use in these reports - you create it in your golden dataset PBIX and republish. A simple refresh in your “dependant” reports will pull these in. Any changes you make to the structure or relationships etc in the golden dataset will also be available in your “dependent” reports.
As long as you keep your golden dataset up to date either by schedule refresh or manually - the other reports will always pull that data.
Hope that helps in some way for this or future uses perhaps.