cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Not able to add datasource to gateway

HI.. i installed onpremise gatway on azure VM server (cluster). and I am trying to add azure sql database to this gateway but  not able to do that. i am gettig below error. iam using basic authentication to login

'Logging into Sql server failed. Possible reasons for this error include an invalid authentication mode, a missing login in Sql server, a login from an untrusted domain or a problem contacting the domain controller for the authentication request.'

 

i want to know if it is even supported to add azure sql database to a gateway installed on azure VM. ?

 

i know we dont need a gateway in this case since it is a azure sql database but we have some users not able to refresh it directly so we thought adding it to gateway n see.

 

can anyone suggest ? 

@v-frfei-msft can u help?

 

10 REPLIES 10
Anonymous
Not applicable

@v-frfei-msft

@v-lili6-msft  can someone suggest ..

v-lili6-msft
Community Support
Community Support

HI, @Anonymous

Refresh data in azure sql database doesn't need gateway,

and you said there some users not able to refresh it directly, whether it is reason IP rights for azure SQL server connection?

 

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

@v-lili6-msft im aware the gateway is not needed but why am i not able to add it to gateway? is it not supported? and if i add it to gateway does it make any difference? is direct refresh better/can u suggest?

and  iam not quite sure why users are not able to connect to the database...i guess its becoz IP rights or firewall issues..

 

I have other issue as well with sap hana datasource. I added that to a gateway that is installed on azure server but when the dataset is refreshed, im getting this error...

"comunication link failure: 10709 connection failed (RTE:300012) Cannot create SSL engine. The certificate chain was issued by an authority not trusted."

 

can u help? 

Anonymous
Not applicable

Hi @Anonymous

 

I would suggest making sure that the SSL Certificate is valid for the connection to SAP Hana





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Anonymous
Not applicable

@GilbertQ in this case, should we apply ssl certificate for azure on sap hana server or other way. like  apply hana certificate in azure server?

I would suggest looking to see which SSL Certificate it is referring to. And then ensure that it is a valid ticket.




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

GilbertQ
Super User II
Super User II

Hi there

I would imagine that you could use Microsoft Flow after the Power App data has been captured. I am fairly certain that you can connect to your exchange server in Microsoft Flow.

To try this press CTRL + F5




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

GilbertQ
Super User II
Super User II

Hi there

Could you possibly check if it is your browser that is caching the background?

To try this press CTRL + F5




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

GilbertQ
Super User II
Super User II

Hi there

I would think that you would not need the gateway to refresh. The users could just click on the Refresh now option for the dataset?




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Top Solution Authors