Forum Discussion

DeBIe's avatar
DeBIe
Post Partisan
5 years ago
Solved

Update multiple reports

Hello all,   I would like to know if I can improve my way of working with updating multiple reports.   The situation now is: I have 10 reports with exactly the same visuals. The only difference i...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    5 years ago

    DeBIe - Maybe something via the Power BI REST API but the best thing to do in your scenario is to use Row Level Security (RLS) and that way you only have a single report to deal with.

DeBIe's avatar
DeBIe
Post Partisan
5 years ago

Greg_Deckler 

 

I understand that I can enable RLS and set up access rights for multiple users for the same dataset. But is this also possible with multiple customer environments (multiple SQL-databases)? 

 

Greg_Deckler's avatar
Greg_Deckler
Community Champion
5 years ago

DeBIe - Are you bringing all of those multiple SQL databases into a single Power BI dataset? Is this a Direct Query situation?

  • DeBIe's avatar
    DeBIe
    Post Partisan
    5 years ago

    Greg_Deckler 

     

    I've tried to draw this in paint lol. Hopefully, this makes it clear what I'm looking for?

     

    • Greg_Deckler's avatar
      Greg_Deckler
      Community Champion
      5 years ago

      DeBIe - Right, what I am talking about is creating a single Power BI dataset that includes ALL of the SQL databases for ALL of the customers. You then apply RLS to that so that each customer only sees their own data.

      • DeBIe's avatar
        DeBIe
        Post Partisan
        5 years ago

        Greg_Deckler 

         

        Thanks for your reply. Is there a website/article with an explanation of how to do this?