Forum Discussion
Aghiles89
4 years agoRegular Visitor
How import data from the active SQL DATABASE?
hello, We have two SQL database, primary and mirror, using BI Desktop i import data from the active database, but when the primary databse is down the second(mirror) becomes the principal. My questi...
otravers
Community Champion
4 years agoThe SQL connector has a failover option:
- https://docs.microsoft.com/en-us/power-query/connectors/sqlserver
- https://www.youtube.com/watch?v=GBKVGWpvH6s (video for Azure SQL)