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?
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_TableName
