Forum Discussion
Sharing a Standard Report with Different Clients
If I could access all the databases using a single user, yes that was the solution, but I'll have a different user for each client as their have their data on premises in different servers.
I'm almost sure there is something related to Azure Active Directory, but I'm lost there, if someone could point the directions please.
Thanks you all
Super UserHi Anonymous ,
We once had the same situation, we resolved it by using RLS on the report. And, we had an existing "portal" for the external clients to log into already so we used the UPN for the sign in to set the RLS to make sure that the right clients only saw their data. They all needed a license but we worked through that as to who would buy the licenses.
I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!
Hi Collinq
Please correct me if I'm wrong but in your case you had all the data built in a single model (data from all clients) and used RLS to slice according to whom login. But see my problem is that I dont have all the data under my belt ,the clients data is sitting in completely different locations and I need to find a way to the pbi online portal to redirect the connection to each client DBs without the need to me to log in in each client pbi online portal and manually change the connection string from my own DB (development DB) to their DB (production DB).
please let me know if this clear.
Thank you though
- collinq
Hey Anonymous ,
What about creating a Dynamic Parameter in the report that points to the right DB based on the client? I think that would work - this would be your datasource parameter. Each Query would point to the parameter. Then, when the client logs in, they get the right paramater based on the sign on/client name/whatever. (The setup would be a one-time pain but this is very scaleable and if a client isn't a client anymore very easy to remove a paramater.)
I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!
If I could access all the databases using a single user, yes that was the solution, but I'll have a different user for each client as their have their data on premises in different servers.
I'm almost sure there is something related to Azure Active Directory, but I'm lost there, if someone could point the directions please.
Thanks you all