How to use separate credentials for the same data source for 2 different reports?

[jarwest]

Hey all,

Like it says on the tin, I have 2 different sets of credentials for the same data source that I need to use for PBI Reporting.

I have my usual credentials, lets call them credential_A, that I use for everything. It's a service account credential that I and another PBI developer I work with use to connect to a SQL server the data for our reports is stored on.

However, for a recent report, I needed to make it so only I can access it, so we made another service account credential, let's call this one credential_B, that can access specific schemas on the SQL server. 

Whenever I publish the recent report, it fails to refresh because it thinks I'm using credential_A. But, when I try to change it to credential_B, it changes my login to credential_B for every other report I own, disabling several other reports. I'm changing my credentials back to credential_A, but this doesn't fix the recent report in question. 

How do I use credential_A on other reports, but credential_B on the recent report?

Any and all help is appreciated

[Greg_Deckler]

@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.

[jarwest · Accepted solution]

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!