SSAS Connection String - Application Name

Trevor Howe (SI) 0 Reputation points
2024-08-20T15:12:02.86+00:00

Hi

We are using the SSAS DMV's to extract usage information via DISCOVERY_SESSIONS, DISCOVERY_CONNECTIONS, and DISCOVERY_COMMANDS. DISCOVERY_CONNECTIONS has a column for the application (CONNECTION_HOST_APPLICATION). This is very handy as we have our cubes being queried from 3 main sources (Power BI, SSRS, and Excel). I found that this column is not populated for these 3 but for some other apps (Dax Studio and SQL Management Studio) it is populated. I have read that you can set the Application Name in the connection string of the cube. I have tried this in various different ways, but nothing is working. Is there something that I am missing. Below is an example of a connection string for a power bi dashboard connected to a cube (both in house/on prem):

Data Source=srv999999;Initial Catalog="Blah Blah Cube";Cube="Blah Blah Model";Application Name=PBI;

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,690 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,278 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. MikeyQiaoMSFT-0444 2,790 Reputation points
    2024-08-21T02:51:26.6266667+00:00

    Hi,Trevor Howe (SI)

    You can try to modify the format.:

    ApplicationName='PowerBI';


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.