Skip to main content

    Power BI

    Needs Votes

    Power BI Gateway and Power BI Service support for "SQL Server Failover support"

    Vote (24) Share
    Pär Adeen's profile image

    Pär Adeen on 24 Apr 2017 17:34:46

    Power BI Desktop has since January had support for "SQL Server Failover support" (robably Always On). But this is not supported from Power BI Service using a Power BI Gateway.

    I don't know if there's a change needed in both the Service and the Gateway, but that's for Microsoft to sort out

    Adding this would rapidly decrease the data needed to be upload to the Power BI Service via the Power BI Gateway. It would also provide near RT access to data

    Comments (6)
    Pär Adeen's profile image Profile Picture

    Richard Stebles on 06 Nov 2024 15:17:54

    RE: Power BI Gateway and Power BI Service support for "SQL Server Failover support"

    Voting on ideas like this feels like screaming into the void.

    Pär Adeen's profile image Profile Picture

    Ludovic Chevraux on 29 Dec 2023 16:27:02

    RE: Power BI Gateway and Power BI Service support for "SQL Server Failover support"

    almost 2024 and this feature does not seem available.surprising that microsoft does not manage SQL Server correctly

    Pär Adeen's profile image Profile Picture

    Andrew T. on 05 Jul 2020 22:57:19

    RE: Power BI Gateway and Power BI Service support for "SQL Server Failover support"

    Yep, managing data refreshes in the service when it can't connect to the database half the time (due to failover not being supported) is a nightmare.

    Pär Adeen's profile image Profile Picture

    Brian Griffeth on 05 Jul 2020 22:53:32

    RE: Power BI Gateway and Power BI Service support for "SQL Server Failover support"

    Agreed. This needs to be put into the PBI Gateway.

    We have a SaaS application that we use as our LOB system that gave us an interface to the data. This feature is what we're missing in order to get the robust reporting in our clients' hands to set our company that much further ahead.

    We are a Microsoft double-Gold partner in Platform and Productivity and have recently started a CSP agreement so this could REALLY make our business and by proxy Microsoft's products shine.

    Pär Adeen's profile image Profile Picture

    Steven.Brown on 05 Jul 2020 22:51:53

    RE: Power BI Gateway and Power BI Service support for "SQL Server Failover support"

    I agree. What is the point in having failover support if it doesn't work in the gateway?

    Pär Adeen's profile image Profile Picture

    Pär Adeen on 05 Jul 2020 22:46:47

    RE: Power BI Gateway and Power BI Service support for "SQL Server Failover support"

    This is the original Blog post for SQL server failover support : https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-january-feature-summary