Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I am connecting to a 3rd party SQL database. They have two different logins for different tables, but they are apparently on the same server and database.
BI is only letting me put in one set of credentials, so when I try to query the other tables, it is saying it is invalid. Is there any way to put in two sets of credentials to the same Database?
Hi, @lathomps1986
What connector do you use to connect to the data source?
If you use this, you can try to clear permission in data source settings and re-connect the data source by alternate credentials.
If you use others, Please tell me about your situation.
Best Regards,
Community Support Team _ Janey
I connect using database credentials. The problem is the server and database names are the same, but there are different logins and passwords to get to different parts of the database/tables. I can connect to both seperately but am looking for a way to not have to be constantly changing the permissions, and really i need to be able to be in both sets of tables at the same time.
Hi, @lathomps1986
Have you tried adding two data sources with different credentials in the service's gateway? This maybe helps.
@lathomps1986 , Try to add database name in URL, so there is a difference in that. Assuming database name is different even if URL is same
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |