My organisation has many clients.
Each client has his own database (the same structure).
We would like to create a few reports and share the reports with them.
In the future, if a report will change, instead of changing for example 50 files (50 clients), we would like to change only one.
What is the best solution for this?
I was thinking about 2 solutions.
Merge all databases into one and use RLS - but this is very risky
Solution is:
Create a report in Power BI desktop and use parameters (hostname and database).
Create a separate workspace for each client and export the report
Set the parameters for each client.
Share the workspace with another organisation (client)
The problem is, each time when I change and upload the report I have to set parameters for each client again.
While our users and experts do as much as reasonable to help you with your inquiries, not all concerns can be attended to especially if there are some learnings to be done. Thank you!