Forum Discussion
2 Different Gateway Connections to the Same Database
We have a Power BI report connected to 2 SQL views in the same database. When publishing through the data gateway, we'd like 1 connection to connect with stored credentials and the other connection to use Kerberos and authenticate as the logged in user. However, since they both have the same server/database name, we can only choose one connection method. Can anyone think of how to accomplish this?
2 Replies
Hi simonb89 ,
As far as I know, one gateway supports one data source. If you want to use two gateways, please use two data sources.
If you have other better solutions, please share them, which will be of great help to people who have the same problem in the forum.
Best Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!Hi simonb89 ,
Was my answer helpful to you?
Please accept the answer that solves your problem as a solution and if you have other better solutions, please share them, it will be of great help to others who have the same query as you.
If you have any other questions please feel free to contact me.
Best Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
