Forum Discussion
Connect to Availability Group
Hi! I am wondering how can I connect to a SQL Server using Availability Group Name with the option ApplicationIntent=ReadOnly! Is there any way to enter this information in the Advanced Editor?
Can I configure powerbi.com to use ApplicationIntent=ReadOnly in its connection string? This way I can connect powerbi.com to my availability group and make secondary or any other replica respond to powerbi queries, not the primary replica.
I think this is one of the most important features for AlwaysOn - PowerBI integration. I do not want to connect to a replica by its real address, I want to delegate load distribution to AlwaysOn.