Data Source Settings

[Anonymous]

Hi. I'm supporting a BI report working on one that's in production. And many others have a similar scenario:

In the menu choices File/options and settings/Data Source Settings, 3 data sources are listed. Each are the same but spelled slightly different.  It appears that when you are adding queries with the same datasources spelled differently, PowerBI considers them separate data source settings:

dsdv-inf-1800.xxx.com,63634;OAMC_DATALAKE
dsdv-inf-1800.xxx.com,63634:OAMC_DATALAKE
dsdv-inf-1800.xxx.com,63634:oamc_datalake

In a copy, I converted them over to the following version
dsdv-inf-1800.xxx.com,63634;OAMC_DATALAKE

So far everything seems to be working fine.  My question is, is it even worth doing? Does it make the report more efficient, quicker, or anything else that makes it worth while to do this, spend time testing and than re-release as a production version?
Is it worth going through the effort of keeping it consistent, and do I gain anything by doing this? 
Or maybe just change it whenever a change to the report is requested?

[lbendlin]

It doesn't matter much for the report on your PC. It matters A LOT  on the Power BI service. A LOT.  Especially when your data source is considered on-prem and requires a gateway,  Unless your connection strings match EXACTLY between desktop and gateway the gateway will not be selectable.

So yes - absolutely go through that exercise. Best approach is to create parameters for server and database, and then have all queries use these parameters instead of hardcoded values.