Power BI & SQL Server Always On Availability Groups

In this video, Patrick shows how you can successfully connect to your SQL Server Always On Availability Group (AG) Secondary Read Replica using Power BI Desktop and the On-Premises Data Gateway. Adam jumps in to show you what the connection string looks like when you use this approach.

Configure Read-Only Routing for an Availability Group (SQL Server)

2017-09-07T10:48:21+00:00