Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
hariaw
Frequent Visitor

Should I create 1 Report or 1 Dashboard or 1 App for multiple departments?

Hallo all,

 

I would like to know your opinion in the following case:

 

So, I need to create Power BI reports for multiple departments (finance, marketing, etc) in the company. In each department, they have large amount of dataset needed to be visualized. The requirements are that people can only see the data of their own department. And we can easly adjust the report if there are new requirements/dataset in each department. My question is, if I need to create all these reports, should I:

- Multiple pages: Create 1 report with multiple pages (1 page for each department),

or

- Multiple reports: Create 1 report for each deparment,

or

- Multiple workspaces: Create 1 workspace for each department?

 

And how about the art of publishing these reports? Which one is more secure: get the audiences access the workspace, or just publish an app? Is it even possible to restrict ones access to a specific report if they having access to the workspace?

 

I hope my question is make sense. I'm quite new to Power BI, that why I need your guide😊

 

Thank you

 

 

 

3 REPLIES 3
R1k91
Solution Supplier
Solution Supplier

you could use also multiple workspaces (grouping departments if needed) but always use app to share and audiences to segregate reports among multiple users accessing the same app.

i.e. 

- finance+sales workspace with 3 audiences (see all, see only finance, see only sales)

- warehouse workspace with 2 audiences (see all reports, see only specific reports)

- sales workspace with 1 audience

 

if you need to segregate rows presented inside a report by user accessing (for example Sales Area Manager) use Row Level Security.


--
Riccardo Perico
BI & Power BI Engineer @ Lucient Italia

Blog | GitHub

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
R1k91
Solution Supplier
Solution Supplier

use power bi app to publish, no direct access to workspace and use audience to give access to right people to each report Announcing Public Preview of Multiple Audiences for Power BI Apps | Microsoft Power BI Blog | Micros...


--
Riccardo Perico
BI & Power BI Engineer @ Lucient Italia

Blog | GitHub

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
hariaw
Frequent Visitor

Thank you for the answer!

 

So, to summary that, I need to create:

 

1 workspace -> containing multiple report (1 report for each department) --> publish 1 app and set up the audiences to specific person for specific report

 

right?

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.