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.
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.