Forum Discussion
Connect to Different Datasource by User
Don't know if this is even possible!
Here is what I am trying to do. We have multiple locations each with their own database. All database schemas are identical. I have created reports and dashboards that I want all locations to use. User A (Location A) logs in, runs report and it shows the data from the Location A database. User B logs in, runs report and it shows data from the Location B database. All users have a Pro license.
My original plan was :
1 - Create direct query dataset from database
2 - Create gateway on each database server
3 - Connect user to gateway at their location
4 - Report would use their gateway to serve the data
After further reading, I don't think this will work. Is there a way that I can accomplish this?
8 Replies
either user live connection with credentials pass-through, or implement RLS.
Hi jhcannon,
Maybe your plan will be work, what error message did you receive?
Please provide datails.
Best Regards,
Link
Sorry - just had time to really test today with someone on the other end. We are not getting any error messages. When he opens the report, he sees my data. I am using Direct Query with a dataset. I would expect it to pull the data from his gateway connection but it still shows mine - even when he refreshes. Security wise, I don't want him to see my data or vice versa.
My ideal solution would be that the report is located in a central workspace with everyone having access so that I can maintain the actual report file. When he logs in to the Power BI Service and views the report from his location, the gateway on that computer (setup using his email) points to the database on that computer. The report uses that database to show data. He would never see my data and I would not see his. But what it looks like is happening is his gateway is giving him access to my database.
I think maybe I have misunderstood what the gateway does or I have set up the gateway incorrectly. Any advice?
Hi jhcannon
The only functionality of a Gateway is to connect the dataset to the data source a nd refresh. In my understanding of your case is that you need to install a separate on-premise Gateway for each data source, duplicate the report and connect them to the 2 datasources then publish both reports to the workspace. Connect each of them dataset to the correspondent Gateway and source.
Performance wise I think it is better
Good Luck
