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 Hi,

 

I do not yet pull in the data from all customers at once. What I do is change the data source to the desired cliënt, wait for it to load in all the data. After that, I will publish it to the workspace of that specific cliënt. I have like 15 cliënts so with every update I have to do this 15 times. The way I think this will be possible to solve with RLS is:

 

Pulling in all 15 tables from the clients, add a column with cliënt name, then merge all. And then add RLS based on the Client name column. I wonder if this is going to work after merging the data and reaching +5.000.000 records. Probably I should be able to select the RLS filter in the query editor before loading the data into the model...