As an organization that has been avidly using Power BI, we have developed hundreds of reports that need to be accessed across the enterprise. For non-technical users, Power BI Apps are a perfect solution. However, currently our reports are organized in to only two workspaces, those that are used internally by employees and those that are developed for clients externally.
Ideally, we would like to create a separate Power BI App for each of our 15 some departments to prevent non-technical end users from having to search hundreds of reports to access the data they want. The current system would limit our organization to creating only two apps unless we dissembled the current system and rebuilt 15 individual workspaces containing duplicates of the reports for each department. The fact is, however; that many of the reports are applicable to many different business units.
Is there any workaround for this. Perhaps creating a new workspace for each app and then copying reports to that workspace?? The only issue with that is we would end up with numerous "copied" reports. That would mean that every time a report is changed, we would have to repeat that process for EVERY single workspace. Or at least that is my current understanding.
Thanks @GilbertQ .
Did you find any way to hide set of reports from group of people.
for example : if i have 2 sets of reports,set1 is for group1 and set2 for group 2, and I dont want to see set1 reports by group2 and vice versa.As there is only one app in a workspace, how can we handle this situation(hiding reports ).
(note: i am aware of RLS , but in that case group2 will know that there is a set1 reports as they can still see those empty reports, i want to hide reports)
Hi @PBILover ,
You can use shared dataset option to create multiple report and published the reports as an app.
While publishing into the app , you can include and exlude few reports and dashboards and in permission section add the users to have acceess.
Then you still would have to create a seperate workspace for each app, which means potentially duplicating a lot of content. The sugeestion here is to allow multiple apps in a single workspace. In that case what you suggest here would work perfectly.
Thanks for the reply @GilbertQ ,
Idealy each business unit would need access to both reports that are specific only to them and reports that are useful to all business units. My understanding with the trouble of using RLS is that even if aperson does not have access to a report, they still see a blank screen where the report would be. If we ended up putting hundreds of reports into the same application, the application would become extremely cluttered despite having catered access to specific people using RLS, especially amonst those who only need access to one or two reports. This would essentially defeat the purpose of the goal which is to make the interface simpler and more clear for non-technical end-users.
Would this be something possible in a future release? It would make sense to be able to create user group specific apps, without having to publish the same datasets to multiple different workspaces.
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
Click here to read more about the July 2021 Updates
Did you know that you can visit the Power Query Forum in Power BI and now Power Apps