Forum Discussion

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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 ?

    • CaveOfWonders's avatar
      CaveOfWonders
      Helper IV
      3 years ago

      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.

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        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 ? 

         

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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