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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

On-Premises Data Gateway - Invalid Credentials

1. Dashboard uploaded w/ SharePoint data connection only
2. Data source added to on-premises data gateway
3. Data source connection successful via gateway
4. Align data source to gateway
5. Attempt refresh
6. Fails w/ invalid connection credentials
 
Last refresh failed: Thu May 25 2017 15:26:24 GMT-0500 (Central Daylight Time)
Invalid connection credentials.
Hide details
Underlying error code:-2147467259
Underlying error message:The credentials provided cannot be used for the Web source. (Source at http://team/sites/DataRequest/DataRequestPortal/Forms/DataExtract.aspx.)
DM_ErrorDetailNameCode_UnderlyingHResult:-2147467259
Microsoft.Data.Mashup.CredentialError.DataSourceKind:Web
Microsoft.Data.Mashup.CredentialError.DataSourcePath:http://team/sites/DataRequest/DataRequestPortal/Forms/DataExtract.aspx
Microsoft.Data.Mashup.CredentialError.Reason:CredentialInvalid
Microsoft.Data.Mashup.MashupSecurityException.DataSources:[{"kind":"Web","path":"http://team/sites/DataRequest/DataRequestPortal/Forms/DataExtract.aspx"}]
Microsoft.Data.Mashup.MashupSecurityException.Reason:CredentialInvalid
Cluster URI:WABI-US-NORTH-CENTRAL-redirect.analysis.windows.net
Activity ID:614e1fba-bb65-4c1c-8821-dd7a5503fb25
Request ID:86c5a8cf-41c6-b3a0-8550-9f35d9ea6e62
Time:2017-05-25 20:26:24Z
Status: Needs Info
Comments
v-haibl-msft
Employee

@PowerDAX

 

Are you connectting to SharePoint online? I tried with the built-in SharePoint connector and web connector in Power BI Desktop, and then publish to Power BI Service. Both scenarios can be refreshed properly after edit credential with correct user and password in dataset settings.

 

Best Regards,

Herbert

Vicky_Song
Impactful Individual
Status changed to: Needs Info
 
PowerDAX
Resolver III

Sorry - I should have been more clear.

 

1. SharePoint connection is on-premises and using web connector:

 

let
Source = Web.Page(Web.Contents("http://team/sites/DataRequest/DataRequestPortal/Forms/DataExtract.aspx ")),
Data0 = Source{0}[Data],
#"Changed Type" = Table.TransformColumnTypes(Data0,{{"", type text}, {"2", type text}, {"Name", type text}, {"3", type text}, {"Created By", type text}, {"Created", type text}, {"Modified By", type text}, {"Modified", type text}, {"AssignedToPerson", type text}, {"Promise Date", type date}, {"Status", type text}, {"Priority", type text}, {"DR Summary", type text}, {"Need By Date", type date}, {"DR Description", type text}, {"Completion Date", type date}, {"Acknowledge Date", type date}}),
"

PowerDAX
Resolver III

Hello?  any update?

 

i changed to ODATA connection and it works fine but wanted to work through the web connection issue.