Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Enable SQL Server Failover Support for Published Dataset

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? 

 

Stand_4-1641276649640.png

Additional References:

Stand_6-1641276871828.png

 

Figure 1 - PowerBI Desktop error without SQL Failover Support enabled

Stand_7-1641276985187.png

Figure 2 - Enabling SQL Server Failover Support in PowerBI Desktop



 



1 REPLY 1
V-lianl-msft
Community Support
Community Support

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.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.