On-Premises Data Gateway - Invalid Credentials

[PowerDAX]

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

[v-haibl-msft]

@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

[PowerDAX]

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]

Hello?  any update?

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