Hi,
I hope you can help me.
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 (data from their own database).
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.
Any suggestions?
