Enable SQL Server Failover Support for Published Dataset

Anonymous — Tue, 04 Jan 2022 06:17:30 GMT

Hi All,

I have an SQL datasource which only supports "read only application intents" (see Figure 1). The community solution to this problem is generally to "Enable SQL Server Failover Support" in PowerBI (see Figure 2). This solution works fine in the PowerBI desktop client however when I publish my report and datasource I recieve the following error. How can i enable SQL Server Failover support for a datasource once its published?

Additional References:

Figure 1 - PowerBI Desktop error without SQL Failover Support enabled

Figure 2 - Enabling SQL Server Failover Support in PowerBI Desktop

Re: Enable SQL Server Failover Support for Published Dataset

V-lianl-msft — Fri, 07 Jan 2022 05:31:11 GMT

Hi @Anonymous ,

Make sure that you have got the permissions to add data sources to the Gateway in the Power BI Service.

Please refer to this blog:

https://community.powerbi.com/t5/Community-Blog/Refreshing-data-in-Power-BI-from-SQL-Server-Read-only-or/ba-p/568908

BTW, currently for DirectQuery you can only use the Sql.Database .

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

topic Enable SQL Server Failover Support for Published Dataset in Developer

Enable SQL Server Failover Support for Published Dataset

Re: Enable SQL Server Failover Support for Published Dataset