Enrich applicaiton name property when connecting to SQL Server databases

[R1k91]

When Power BI executes queries against SQL Server, it connects using the Mashup Engine or Mashup Engine (%HostContext%)) as program_name.

In a crowded environment, it can be difficult to identify which semantic model is responsible for activity or issues on the SQL Server side. The desired outcome is to be able to run sp_whoisactive (or query sysprocesses) and see the semantic model name in the program_name column (or something that easily idenfity the source of the query).

For example:

Mashup Engine - Semantic Model "Sales_Model_A" (Name or GUID)

[Thor89]

Expanding on this in the case where a user is querying from Power BI Desktop the program name could indicate that. This would also help identifying Desktop vs Gateway traffic. For example: Mashup Engine - Desktop