Forum Discussion

vamshikrishna20's avatar
vamshikrishna20
Icon for Helper III rankHelper III
3 years ago

Connection Strings in Power BI

Hello All, 

 

I have a requirement on Power BI Diaster Recovery. my data source is Azure Synapse sql server and we have two servers set for this . one is primary and other is secondary which will be used when there is any failover in Primary. In the report i want to pass two servers in a connection string which should ideally check like first goes to Primary if that is available/able to connect and if that is not available then it should connect to secondary server.

 

Please let me know if we can achive this. 

 

TIA

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi vamshikrishna20 ,

    So far, to my knowledge, this may not be achieveable.

     

    Best regards,
    Community Support Team_Binbin Yu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.