Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Enrich applicaiton name property when connecting to SQL Server databases

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)

Status: Needs Votes
Comments
miguel
Community Admin
Status changed to: Needs Votes