Managing credentials for multiple sources

[CarlsBerg999]

Hi,

I have connected to multiple data sources to create a report. However, all the data sources work with the same credentials, so for example in the picture below, all Odata sources work with the same username and password. Changing this username and password is very cumbersome if i have to do it manually by opening each "Edit credentials" one-by-one. 

Is there a more efficient way to managing credentials? Like a "master credential"? The Odata's are all for SAP for example, so a single sign on would suffice. 

Thanks in advance!

[amitchandak]

@CarlsBerg999 , Are using some custom queries or something else because of which you are getting so many connections. There should be some property used in URL or you added custom queries. Please check and current in the file, it should automatically merge here. We had the same issue. We corrected connection details for table and they got merged

[CarlsBerg999]

Hi,

No, these are all individual URL's to which a connection is made separately. Each data source is a separate entity and this is an expected behavior to my eye. However, I would wish that there would be a "master password" for the url. Basically i connect to "http://mysapclient8488.com/report1.....n". What i could imagine is, that there would be possibility in PowerBi to save a password for mysapclient8488 rather than to individually type the password for all reports that are specified in the later part of the url.