Credential Error

[jmiridium]

Getting the following error with a report:

Failed to update data source credentials: Login failed for user 'domain\user'.Hide details

Activity ID:	2feb40c1-b9c0-7fb9-9494-13046ba7387d
Request ID:	b7980091-e0d8-019e-a7b2-908c8f4bf3ea
Status code:	400
Time:	Fri Jul 28 2017 08:43:53 GMT-0700 (US Mountain Standard Time)
Version:	13.0.1828.219
Cluster URI:	https://wabi-west-us-redirect.analysis.windows.net

My credentials are fine. It's acts as if it's not even trying. Need help fixing. Report is critical

[v-qiuyu-msft]

Hi @jmiridium,

From the error message, it seems the report get data from SQL Server database, right?

Please go to the dataset settings, check which kind of gateway used by the dataset.

Verified the credential entered in gateway is correct and still has permission to SQL Server database. Please try to update the gateway to the latest version. For Power BI Gateway - Personal, the latest version is called On-premises data gateway (personal mode).

Best Regards,
QiuyunYu

[jmiridium]

Underlying error code:	-2147467259
Underlying error message:	Microsoft SQL: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
DM_ErrorDetailNameCode_UnderlyingHResult:	-2147467259
Microsoft.Data.Mashup.ValueError.Class:	11
Microsoft.Data.Mashup.ValueError.DataSourceKind:	SQL
Microsoft.Data.Mashup.ValueError.DataSourcePath:	server.domain;DB
Microsoft.Data.Mashup.ValueError.Message:	Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Microsoft.Data.Mashup.ValueError.Number:	-2
Microsoft.Data.Mashup.ValueError.Reason:	DataSource.Error
Cluster URI:	WABI-WEST-US-redirect.analysis.windows.net
Activity ID:	5f64fd67-13e8-4699-b529-f5ff09fe167b
Request ID:	b41304ee-4f0f-4da0-85c2-79d723ea5f2b
Time:	2017-07-28 07:57:18Z