Power BI
Needs VotesPower BI Gateway and Power BI Service support for "SQL Server Failover support"
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 (5)
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
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.
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.
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?
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