Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
can we add more connection attributes such as adding ApplicationName in Connection string
Solved! Go to Solution.
@PBIDev wrote:
Thank you. WE are using SSAS with import mode , and we want to change in Power BI dashboard connections.
The approach only works in SQL Server database in DirectQuery mode. For SSAS, as far as I know, it is not possible.
@PBIDev wrote:
Hi,
can we add more connection attributes such as adding ApplicationName in Connection string
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.
Thank you. WE are using SSAS with import mode , and we want to change in Power BI dashboard connections.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
17 | |
2 | |
2 | |
1 | |
1 |