Is it possible to change powerbi connection string to add ApplicationName?

[PBIDev]

Hi,

can we add more connection attributes such as adding ApplicationName in Connection string

[Eric_Zhang]

@PBIDev wrote:

Hi,

can we add more connection attributes such as adding ApplicationName in Connection string

@PBIDev

Are you talking about the REST API Set All Connections? If so, you keep in mind that it only works for datasets in direct query mode.

For SQL Server, by default the connection strings are like

data source=servername;initial catalog=dbname;persist security info=False

As per my test, you can update the connection string with Application name

data source=servername;initial catalog=dbname;Application Name=MyAppName;persist security info=True

Then the updated  connection string actually works if I observe the connections from SQL Server with SP_WHO2.

[PBIDev]

Thank you. WE are using SSAS with import mode , and we want to change in Power BI dashboard connections.

[Eric_Zhang · Accepted solution]

---

@PBIDev wrote:

Thank you. WE are using SSAS with import mode , and we want to change in Power BI dashboard connections.

---

@PBIDev

The approach only works in SQL Server database in DirectQuery mode. For SSAS, as far as I know, it is not possible.