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

We've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register now

0

Error while creating data source on SQL server Failover cluster

we have setup sql server failver cluster. I am trying to create a data source on power bi cloud (manage gateway -> new data source) to cluster. i have given cluster IP as server and Db name, however it throws below error. Are we missing any configuration settings on gateway or any where else?

 

Please note : From Power BI gateway machine i am able telnet to cluster ip on 1433 port

 

Unable to connect: We encountered an error while trying to connect to XXX.XX.XX.148. Details: "The analysis request operation is timed out before it was completed."Hide details

Activity ID:40ad5433-6533-7df6-0391-0cb9af0410e8
Request ID:7e789a75-78d9-85f7-0dd6-18407389e2bb
Cluster URI:https://wabi-south-east-asia-redirect.analysis.windows.net
Status code:400
Error Code:DM_GWPipeline_Gateway_TimeoutException
Time:Sat Aug 26 2017 12:31:00 GMT+0530 (India Standard Time)
Version:13.0.2201.174

 

 

Status: Delivered
Comments
v-haibl-msft
Microsoft Employee

@mcprakash

 

Currently Power BI Gateway does not support "SQL Server Failover". As far as I know, this may be available later in CY17.

You can also vote on https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/19027669-power-bi-gateway-and-pow....

 

Best Regards,
Herbert

Vicky_Song
Impactful Individual
Status changed to: Delivered