Read Datasource connectivity status

Hi guys,

Please help me know if there is any way to connectivity status of source. let me precise this

I have a requirement say - my reports are sourcing from azure synapse and since there is failover groups set for synapse, we have 2 synapse servers primary and backup. when there is a failover in primary server , power bi should automatically fetch data from backup server. knowing this is not possible in power bi by default, workaround iam thinking is - if there is any way to read connection status of Primary server like if connection success, return 1, else 0 and in advanced editor of my main table, i can write condition as if 1, connect to primary else connect to secondary

Please let me know if this can be achievable