Forum Discussion

MichaelDoig's avatar
MichaelDoig
Advocate I
5 years ago

Data Flow and Failover Support

Hi all,   Earlier this year our DBA's enabled failover support in our Azure SQL Server and thus allowed us to take advantage of Power BI's Failover Support through the Enable SQL Server failover su...
Dataflow
Need Help
MichaelDoig's avatar
MichaelDoig
Advocate I
5 years ago

Thank you.

 

I have engaged with Microsoft Support who did understand the question. There is an issue that can be worked around if you make use of an on-premise gateway with failover support.

 

The Microsoft Product team has been made aware of the issue via our contact with Microsoft. If anyone faces this issue, let me know and I'll guide you through what we did.

 

Regards,

Michael 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hello Michael, can I please know what you did to get the read-only replica for dataflows?

  • PaulKn's avatar
    PaulKn
    Advocate II
    3 years ago

    I am experimenting with an Azure SQL Database running on the Business Critical compute tier and trying to force queries to run against the read-only replica. I have been using the test query detailed here Connecting Power BI to Azure SQL Read Scale Out REPLICA – Kloudspro to verify if Power BI is connecting to the read only replica.

    It seems to work ok with data sets and data marts, but (as per with the original post from 2.5 years ago)  not with dataflows unless I connect through our on-premises data gateway (which seems a bit of an unnecessary thing to have to do with an Azure SQL database). 

     

    This is an old post so I won't hold out hope for a reply, but were you given any explanation from Microsoft as to why you have to use a gateway MichaelDoig?