cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
tiktoska New Member
New Member

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 7
Super User IV
Super User IV

Re: Connect to Availability Group

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


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Ubbink New Member
New Member

Re: Connect to Availability Group

Is there already a solution for the "application intent" error?

schuhtl Visitor
Visitor

Re: Connect to Availability Group

Has anyone found a solution for this yet?

mcolb88
Advisor

Re: Connect to Availability Group

Did this ever get resolved? This is very important for DirectQuery mode.

kaulug Frequent Visitor
Frequent Visitor

Re: Connect to Availability Group

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.

kaulug Frequent Visitor
Frequent Visitor

Re: Connect to Availability Group

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.

Re: Connect to Availability Group

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.

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors