Reply
CaveOfWonders
Helper IV
Helper IV
Partially syndicated - Outbound

Deleted

Deleted

5 REPLIES 5
RJOttenheim
Resolver I
Resolver I

Syndicated - Outbound

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

 

RJOttenheim
Resolver I
Resolver I

Syndicated - Outbound

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 ?

Syndicated - Outbound

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.

Syndicated - Outbound

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 ? 

 

avatar user

Helpful resources

Announcements
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!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)