Forum Discussion
How to use separate credentials for the same data source for 2 different reports?
I don't believe that is an option for me, but I found a workaround. My team uses a gateway, I was able to add a new connection pointed to the same place just renamed, using the new credential. Everything is working smoothly now, I apologize for making a question just to answer it myself. Thanks for your help!
jarwest My suggestion would be to create an alternate DNS entry or something for your SQL Server or create the connection using the IP address or something versus the friendly name. Basically, you need to create an alternate connection that Fabric *thinks* is different from the current one.
I don't believe that is an option for me, but I found a workaround. My team uses a gateway, I was able to add a new connection pointed to the same place just renamed, using the new credential. Everything is working smoothly now, I apologize for making a question just to answer it myself. Thanks for your help!