Can't enter credentials, it's trying to use gateway..?

[WHH]

Hi all you wonderful folks

Anyone come across this before? can't work out what to do next. I just published a dataset which uses a connection to a on-prem SQL server (which is already on our enterprise gateway) and also links to a few SharePoint sites. but it won't refresh. the data credentials is grey'd out:

and when I go to gateway settings all it offers me to do is add them to the gateway which I don't want to do, and shouldn't need to do (the SQL server is already added and the others are SharePoint online). It's in a Premium capacity workspace.

not sure what to do... Please offer suggestions.

thank you lovelypeople

[v-yetao1-msft · Accepted solution]

Hi @WHH 

First, you need make sure that your gateway can run normally and the data from SQL can refresh successfully in Service .Then when you add links from SharePoint to dataset and publish to Service ,you just need to operate in two steps.

(1) Under Gateway Cluster Settings, select Allow user's cloud data sources to refresh through this gateway cluster > Apply.

(2) On the Dataset settings page for the new dataset:

• For the on-premises source, select the gateway associated with this data source.
• Under Data source credentials, edit the cloud data source credentials, as necessary.

The final result is as shown :

Best Regards

Community Support Team _ Ailsa Tao

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

[aj1973]

Hi @WHH 

For sharepoint files there is no need for Gateway but for the SQL server yes, you need a Gateway.

Test if you can connect a Sample Dataset from SQL server and another Dataset from Sharepoint and see whether they can be refrshed! maybe one of them is not well configured.

If all is good then a combination of both connection shouls look like this