Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Next up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now

snk

Direct Query not working with SQL Server 2016 Always On Capabilities

Submitted by on ‎04-16-2018 06:25 AM

Upgraded our SQL Server database 2012 to 2016 which came with always on capabilities. In the process, our Power BI reports utilizing direct query from the database started breaking giving us 'availability group errors'.

 

To mitigate this,I enabled SQL Failvoer support in my edit queries button and configured the connection string with 'Application Intent Read Only'. Despite this, I am unable to get any direct queries to work with the new SQL Server.


Is anyone else experiencing the same issues and has any suggestions on how to resolve this??

Thanks.

Status: Needs Info
See more ideas labeled with:
3 Comments (3 New)
Comments
v-qiuyu-msft
Community Support
Community Support
‎04-18-2018 02:56 AM

Hi @snk,

 

Are you able to connect to the same SQL Server database in SSMS remotely successful? 

 

Would you please share detail error message when you connect to the SQL in Power BI desktop?

 

Best Regards,
Qiuyun Yu 

 

Vicky_Song
Impactful Individual
Impactful Individual
‎04-18-2018 02:57 AM
Status changed to: Needs Info
 
snk
New Member
‎04-18-2018 05:56 AM

I am able to connect to SQL Server remotely and run import queries on Power BI. Just not direct queries. The database connection string has been configured for application intent read only and I still continue to get this alert.

 

 

Error.PNG

Idea Statuses