How To Connect Power BI to Read-only Replica of Azure SQL Database directly?

Hi KylanJin ,

I was able to find a similar request to this in the forums: https://community.fabric.microsoft.com/t5/Desktop/PowerBI-Connect-to-ReadOnly-Replica-of-Azure-SQL-Database/m-p/4049608#M1285854

The solution in this post links several articles with methods to connect to your Read-only Replica of Azure SQL Database.

If this helped, please mark it as the solution so others can benefit too. And if you found it useful, kudos are always appreciated.

Thanks,

Samson

Will connecting to the read-only replica affect primary database performance?

No, connecting to a read-only replica does not impact the primary database’s performance because read-only replicas handle only read workloads, offloading queries from the primary.

Is the server name of the read-only replica different from the primary?

Usually, yes. The read-only replica often has a different server or listener name configured for routing read-only connections. In Azure SQL, you connect to the primary server’s read-only listener endpoint or a specific read-only replica endpoint.

You can refer to the following official Microsoft documentation,

• Azure SQL Database Read Scale-Out
• Offload Read-Only Workload to Secondary Replica