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?
7 Replies
I do not see that option listed for Sql.Database:
https://msdn.microsoft.com/en-us/library/mt260902.aspx
You should be able to use the availability group name of the SQL Server.
let
Source = Sql.Database("AvailabilityGroupName", "DBName"),
dbo_TableName = Source{[Schema="dbo",Item="TableName"]}[Data]
in
dbo_TableNameIs there already a solution for the "application intent" error?
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.
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.
