Forum Discussion
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 is the customer(datasets). I had to deploy a fix and you guessed it, it has to be applied to all reports. Instead of changing the data source one by one to the specific customer and re-publishing it, I would like to know if it is possible to automatically push this fix and apply to all 10 reports. The fix I had to do was done in the query editor.
Thank you for your time. Hopefully, someone can help me.
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.
11 Replies
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.
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)?
DeBIe - Are you bringing all of those multiple SQL databases into a single Power BI dataset? Is this a Direct Query situation?
DeBIe , refer if this can help
https://community.powerbi.com/t5/Desktop/parameterize-connection/m-p/205900#M90712
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...
