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?
Any update? I want Power BI to connect to my AlwaysOn database using ApplicationIntent=ReadOnly in its connection string. So that AlwaysOn will distribute this load to one of my read-intent replicas.
I think this is a very important feature for AlwaysOn - PowerBI integration.
You need to select "Enable Failover Support" on the screen where you define the query. That appends MultiSubnetFailover=True and ApplicationIntent=Readonly to the connection string. One caveat - it only seems to work for the Import, but not Direct Query option. That last bit also seems to be a bug, not a feature.