cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
remig Frequent Visitor
Frequent Visitor

Gateway - refresh failed - "The credentials provided cannot be used for the Web source."

Hi,


I am trying to use the enterprise gateway, but I am getting the following type of 'refresh failed' message for every Sharepoint 2007 List (.aspx) source.

Spoiler
Last refresh failed: Tue Oct 03 2017 17:11:01 GMT+1100 (AUS Eastern Daylight Time)
Invalid connection credentials.
Underlying error code: -2147467259
Underlying error message: The credentials provided cannot be used for the Web source. (Source at http://home.mysite.com/SiteDirectory/pm/Lists/Builds/PowerBI.aspx.)


I think I tried everything and cannot figure out why I get this error. In 'Manage Gateway, I use the 'Windows' authentication method. The 'Windows' authentication methods work fine in Power BI Desktop, and it worked fine with the Gateway installed in Personal Mode a few weeks ago. Moreover, those credentials work just fine for CSV and Excel sources pointing to this sharepoint site.


Thanks you in advance. 

 

5 REPLIES 5
Moderator v-qiuyu-msft
Moderator

Re: Gateway - refresh failed - "The credentials provided cannot be used for the Web source.&quo

Hi @remig,

 

From your description, it seems that the dataset is configured to use on-premise data gateway personal mode. As the error message said, the credential is not valid. Please go to dataset settings, enter the correct credential for the web data source again. 

 large (10).png

 

 

Best Regards,
Qiuyun Yu 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
remig Frequent Visitor
Frequent Visitor

Re: Gateway - refresh failed - "The credentials provided cannot be used for the Web source.&amp

Thank you @v-qiuyu-msft. The dataset is definitely configured to use the on-premise gateway, and I have re-entered the credential a few times so far. I must have spent over 5 hours so far trying everything, and removing one source at a time from my data set, to realise that every .aspx source failed, all the other sources work fine, and they are pointing to the same sharepoint server, and I am using the same credentials.

Capture.PNG

 

 

Moderator v-qiuyu-msft
Moderator

Re: Gateway - refresh failed - "The credentials provided cannot be used for the Web source.&amp

Hi @remig,

 

Please try to update the on-premise data gateway to the latest version. And share the on-premise data gateway service log (C:\Users\PBIEgwService\AppData\Local\Microsoft\on-premises data gateway\Gateway*.log ) around the time refresh failed with us. 

 

Best Regards,
Qiuyun Yu 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
remig Frequent Visitor
Frequent Visitor

Re: Gateway - refresh failed - "The credentials provided cannot be used for the Web source.&amp

Hi  @v-qiuyu-msft, thank you so much for responding. Here is a log file containing the errors. Thank you sooo much for your help.

 

Log file

 

Carlos_mx Occasional Visitor
Occasional Visitor

Re: Gateway - refresh failed - "The credentials provided cannot be used for the Web source.&quo

Hi, I'm facing the same issue evething was working properly yesterday and I updated on-premises gateway to last version and now I'm not able lo connect, I follow some steps (uninstalled, deleted directories, installed again, uninstalled, installed previous version and didn't work).

 

I tried again a few minutes ago and same issue, I've installed last version and this is what I'm getting when I'm trying to restore a previous gateway:

 

Failed to update gateway details. Please try again.
This request operation sent to net.pipe://localhost/powerbi/gatewayconfiguration/service did not receive a reply within the configured timeout (00:01:00). The time allotted to this operation may have been a portion of a longer timeout. This may be because the service is still processing the operation or because the service was unable to send a reply message. Please consider increasing the operation timeout (by casting the channel/proxy to IContextChannel and setting the OperationTimeout property) and ensure that the service is able to connect to the client.

Server stack trace:
at System.ServiceModel.Dispatcher.DuplexChannelBinder.Request(Message message, TimeSpan timeout)
at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout)
at System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall, ProxyOperationRuntime operation)
at System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message)

Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
at Microsoft.PowerBI.DataMovement.Pipeline.InternalContracts.IGatewayConfigurationService.UpdateGatewayConfiguration(UpdateGatewayConfigurationRequest request)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayClient.GatewayConfigurationClient.UpdateGatewayConfiguration(UpdateGatewayConfigurationRequest request)

 

Please help

 

Thanks

 

Carlos

Helpful resources

Announcements
New Ranks and Rank Icons in 2020

New Ranks and Rank Icons in 2020

Read the announcement for more information!

New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

November 2019 Community Highlights

November 2019 Community Highlights

Get an overview of the events and great community content from November.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)