Data Source and other frustrations

[BobF]

My scenario is this.

Three clients each set up with Power BI accounts, works fantastic.

One Azure database, one Admin account, and three accounts set up which match the three client accounts (configured to see only their view) works fantastic (once I figured all the steps out). The Azure database contains data for all clients, 3 views (at the moment) to filter the data for each client. Yes I can use PowerQuery to filter the data. However I cannot share the report with the clients as they are not in our Office365 domain.

Three Power BI accounts one for each of the clients, and three Power Desktop reports for each client.

FRUSTRATIONS !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

To deploy to each PowerBI.com account, I have sign out and then sign in with the specific client account I wish to up load to. Ok its a work around, and I can document it. It works so I'm happy-ish. Yes I can forsee this happening in the future, as we look at other projects.

Data Source Settings 1) I have ONE ! Why? Its shared across all accounts I cannot change the name, or can I?

Data Source Settings 2) whats the relationship between what is seen in the 'Data Source Settings' and the data source used. Is is this line in the M source 'Source = Sql.Database("mydatabaseServer.database.windows.net,1433", "mydatabaseName"),' If so then might how to configure a data source for my three (3) accounts each with a different user name and password?

When I upload the .PIBX desktop report to the PowerBI.com account. It does not overwrite the existing data connections As I understand the work around is to delete the dataset and upload again. Ok I might just add this to the list of requests along with the rest of the ones above.

[BobF · Accepted solution]

Got one answer ( l think today whilst playing) 

M source 'Source = Sql.Database("mydatabaseServer.database.windows.net,1433", "mydatabaseName"),'  Yes this is the same as the data source name that is listed in the 'Data Source Settings' window.  This setting is also Case Sensetive.