cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
richardlhughes
Responsive Resident
Responsive Resident

Gateway failed refresh invalid credentials - Web source for SharePoint on-premise

I have at least 3 of these different datasets that are setup in the gateway and they seem to not be able to connect to the web page (SharePoint URL - on-premise - this one specific is form library). Initially during the setup of the gateway, the connection is established and it seems to work upon the setup. Keep in mind these are web data types. 

 

The Power BI report is published using the same type of data type connection as per the gateway setup, web data type. Then, when trying to refresh the dataset the refresh always fails. I haven't been able to find a work around for this issue. 

 

Here are a couple of blurbs from the verbose logging...

 

++++++++++++++++++++++++++++++++++++++++++++++++++

 

GatewayPipelineErrorCode=DM_GWPipeline_UnknownError
GatewayVersion=
InnerType=MashupCredentialException

InnerMessage=<pi>The credentials provided cannot be used for the Web source. (Source at http://xxxxxxxxxxx.com/LeadershipToolbox/IDP/Forms/All%20Documents.aspx.)</pi>
InnerToString=<pi>Microsoft.Data.Mashup.MashupCredentialException (0x80004005): The credentials provided cannot be used for the Web source. (Source at http://xxxxxxxxxxx.com/LeadershipToolbox/IDP/Forms/All%20Documents.aspx.)

 

++++++++++++++++++++++++++++++++++++++++++++++++++

 

GatewayPipelineErrorCode=DM_GWPipeline_Gateway_InvalidConnectionCredentials
GatewayVersion=14.16.6830.1
Reason=<pi>CredentialInvalid</pi>
DataSource=<pi><pi>Web/http://hr.sp.us.tel.com/LeadershipToolbox/IDP/Forms/All%20Documents.aspx</pi></pi>
DataSourceReference=
DataSourceOrigin=
DataSourceReferenceOrigin= --->
[1]Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.GatewayPipelineWrapperException: Substituted: MashupCredentialException:<pi>Microsoft.Data.Mashup.MashupCredentialException (0x80004005): The credentials provided cannot be used for the Web source. (Source at http://xxxxxxxxxxx.com/LeadershipToolbox/IDP/Forms/All%20Documents.aspx.)

 

++++++++++++++++++++++++++++++++++++++++++++++++++

 

I was wondering if somehow the windows account we are using for authentication needs to have on the SharePoint site, site level read persmission to resolve this issue. I have asked the SharePoint Site collection admin to grant our Windows Service Account access for the Power BI report. However, I don't have solid evidence this is needed or will fix the issue.

 

Also, I am running the October release, most current, Power BI Gateway Service at the moment. Our environment has a single server Enterprise Gateway setup.

 

Any help or ideas  is most appreciated. Thanks in advance!

 

-Richard

4 REPLIES 4
v-yuta-msft
Community Support
Community Support

Hi richardlhughes,

 

Try using data gateway(personal mode) instead of on-premises data gateway and check if this issue will be solved.

 

Regards,

Jimmy Tao

Hi Jimmy,

Thank you for your reply.

 

We don't allow personal gateways in our enterprise. Are you just suggesting I test this for Microsoft to determine if the Enterprise Data Gateway has something wrong?

 

What would I achieve in doing this kind of test?

Thanks,
Richard

henriquesilveir
Resolver IV
Resolver IV

@richardlhughes Hello, all errors are about Invalid Credentials, have you setup up the credentials into app.powerbi.com  too?

 

I Must set it on app.powerbi.com 

 

take a look: 

Go to Setting > Gateways 

 

You will se your gateway name, and insert your credentials there.

 

erro.PNG

Let me know if it help you!

I am most certain the creditials are setup correctly. 

 

LeadershipToolboxgateway.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Let me know if I am missing something from the gateway.

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

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!