- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Deleted
Deleted
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I still have no clue what the problem is. It start to sound like stakeholders want a report for each project.
What you could do is create parameters and then create links to the same report
Call report x with Region 1 Project A
Call report x with Region 2 Project A
Call report x with Region 2 Project B etc
Then you have 1 report that can ( and should) be called with parameters.
Maybe you can create a report that calls another report.
So RLS filters all your links depending on the user. And the link is then used to call another report.
User 1 is in region 1 project A
User 1 is in region 1 project C
User 2 is in region 2 project B
Report 1 then shows links to
report 2 with parameters 1 and A
report 2 with parameters 1 and C
report 2 with parameters 2 and B
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I am confused by this question
Do you create a report per region ? Or per Project ? Or do you take all data and stuff them together ?
Can you make a selection on project and make this selection mandatory ?
So if you select project A you only get to see Project A (regardless of region ?) etc ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
There is one report sitting in the Power BI Service for all regions/projects. RLS deals with security i.e., who can see what. This one report is embedded in all sharepoint sites.
Users cannot select a project through power bi. They can navigate to the region/project they want to see and if they have access then they can view the data.
Hope that clarifies.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
If a user has access to 2 projects then this report shows both projects at the same time ? Is that the problem ?
If so why not create the mentioned filter / selection box ?
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Microsoft Fabric Community Conference 2025
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
123 | |
79 | |
59 | |
58 | |
44 |
User | Count |
---|---|
179 | |
120 | |
82 | |
70 | |
53 |