Forum Discussion
Render PowerBI report(PBIX) inside a visual
IMHO you should keep it easy with out of the box Power BI App + Audiences + Workspace Level Security
Create a power bi app with all the reports inside and 2 audiences:
- audience 1: see all reports- audience 2: see only finance report
the app can have RGB theme color and a logo
Workspace access
- add the SME users as contributor role in workspace so they can create reports and add them to the workspace (and to the app if you want)
- add the SME users to the audience 1 so they navigate the app and see all the reports
- add report consumers to the audience 1 and not to the workspace. they won't be able to create new reports just navigate what is exposed by the audience 1
- add finance consumers to the audience 2 and not to the workspace. they won't be able to create new reports just navigate what is exposed by the audience 2
Thanks KarinSzilagyi for your detailed response,
Here’s the scenario we are trying to address, which stems from some limitations we’ve encountered with PowerApps:
I need to provide access to a workspace for a group of users, where each user plays a different role within that group.
PowerApps initially seemed like the perfect solution, but there are certain limitations. For example:
- I cannot customize the left-side menu based on user profiles.
- A user with an SME role should see all reports in the workspace and also have a link to create new reports.
- A report consumer should only see the list of reports, without the option to create new ones.
- A finance team member should only see finance-related reports within the same workspace.
- I also want to apply a custom RGB theme color, which PowerApps does not currently support.
- There are other customizations I’d like to implement, but the flexibility to achieve them in PowerApps is limited.
As a result, I started exploring the report option, where I aim to build a report that mimics an app-like interface. The idea is:
- When I click a report link in one visual, the corresponding report should render on the right side within the same report.
- When I click “New Report,” I should see that option appear on the right as well.
Note: I am going to try org apps next week and not sure if that solve our problem.
IMHO you should keep it easy with out of the box Power BI App + Audiences + Workspace Level Security
Create a power bi app with all the reports inside and 2 audiences:
- audience 1: see all reports
- audience 2: see only finance report
the app can have RGB theme color and a logo
Workspace access
- add the SME users as contributor role in workspace so they can create reports and add them to the workspace (and to the app if you want)
- add the SME users to the audience 1 so they navigate the app and see all the reports
- add report consumers to the audience 1 and not to the workspace. they won't be able to create new reports just navigate what is exposed by the audience 1
- add finance consumers to the audience 2 and not to the workspace. they won't be able to create new reports just navigate what is exposed by the audience 2