Direct Query with Application Intent= ReadOnly?

[OneWithQuestion]

Is there a way to configure an SQL Direct Query to connect to an availability group's read only route?

Something like: Provider=sqlncli11;data source=aglisten;integrated security=sspi;initial catalog=myDataBase;application intent=readonly

Thanks!

[M_Dhedhy]

Is it still not possible?

[v-yulgu-msft]

Hi @OneWithQuestion,

Based on my research, connecting to a SQL Server using Availability Group Name with the option ApplicationIntent=ReadOnly is not supported by Power Bi right now. You could submit your ideas here.

Please refer to the supported properties in SQL.Database.

Best regards,

Yuliana Gu

[snk]

Has this issue been resolved yet or it still open?

[Nolock]

Hello @snk, @OneWithQuestion,

it is possible when you click on "Enable SQL Server Failover support" in the SQL Server connector - more about it on https://sqlarcher.com/2019/04/09/read-only-replicas-for-power-bi-and-azure-analysis-services/ or https://guyinacube.com/2017/09/06/power-bi-sql-server-alwayson-availability-groups/

[PBIUser135]

^^^ This does not work with DirectQuery