Forum Discussion
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,
Hi KylanJin,
As we haven’t heard back from you, so just following up to our previous message. I'd like to confirm if you've successfully resolved this issue or if you need further help.
If yes, you are welcome to share your workaround and mark it as a solution so that other users can benefit as well. If you find a reply particularly helpful to you, you can also mark it as a solution.
If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.
Thank you for your patience and look forward to hearing from you.
Hi KylanJin,
Hope everything’s going smoothly on your end. We haven’t heard back from you, so I wanted to check if the issue got sorted. If yes, marking the solution would be awesome for others who might run into the same thing.
Still stuck? No worries just drop us a message and we can jump back in on the issue.
Thank you.
Hi KylanJin,
We noticed there hasn’t been any recent activity on this thread. If your issue is resolved, marking the correct reply as a solution would be a big help to other community members.
If you still need support, just reply here and we’ll pick it up from where we left off.Best Regards,
Hammad.