There was an error when processing the data in the dataset

[Anonymous]

Hi Guys, for the past three days, all my dashboards are failing, i'm getting the same error for all of them, can anyone help me fix the problem: Below is the error that i got everytime when i'm refreshing one of my dashboards

Cluster URI:WABI-NORTH-EUROPE-redirect.analysis.windows.net
Activity ID:09f858f7-8acf-450c-ab50-2a8f19373f67
Request ID:e449cbfd-ac34-4809-890e-946cdbdef6c6
Time:2020-03-19 22:34:55Z
or 
Data source error{"error":{"code":"DM_GWPipeline_Gateway_InvalidConnectionCredentials","pbi.error":{"code":"DM_GW
Pipeline_Gateway_InvalidConnectionCredentials","parameters":{},"details":[{"code":"DM_ErrorDetailNa
meCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNam
eCode_UnderlyingErrorMessage","detail":{"type":1,"value":"The credentials provided for the SQL sourc
e are invalid. (Source at zarncdbi01;Avengers.)"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResu
lt","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.CredentialError.DataSourc
eKind","detail":{"type":1,"value":"SQL"}},{"code":"Microsoft.Data.Mashup.CredentialError.DataSourcePat
h","detail":{"type":1,"value":"zarncdbi01;Avengers"}},{"code":"Microsoft.Data.Mashup.CredentialError.Re
ason","detail":{"type":1,"value":"AccessUnauthorized"}},{"code":"Microsoft.Data.Mashup.MashupSecurity
Exception.DataSources","detail":{"type":1,"value":"[{\"kind\":\"SQL\",\"path\":\"zarncdbi01;Avengers
\"}]"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.Reason","detail":{"type":1,"value":"AccessUnauthorized"}}]
,"exceptionCulprit":1}}} Table: Prod TEL_Sales_Tracker.

Cluster URI:WABI-NORTH-EUROPE-redirect.analysis.windows.net
Activity ID:09f858f7-8acf-450c-ab50-2a8f19373f67
Request ID:e449cbfd-ac34-4809-890e-946cdbdef6c6
Time:2020-03-19 22:34:5

[Syndicate_Admin]

I have the same problem for a few days Do you fix?

It only works for me 5 times out of 100 without changing anything...

The error is the same, only the final table that indicates a different one changes each time.

The gateway indicates OK, by PowerBi Desktop updated without issue, everything updated and restarted and nothing has been changed in the reports lately.

[AiolosZhao]

Hi @Anonymous ,

It seems that it's a gateway issue or credential issue.

(You can try to refresh the report in your desktop if you can).

And if you have the access to check the Schedule page of this report, please check whether the gateway is running and whether the data credentials are fine.

Thanks.

Aiolos Zhao

[Anonymous]

@AiolosZhao  Thanks, let me check, i will come back to you if it's working

[v-chuncz-msft · Accepted solution]

@Anonymous 

By the way, you may help accept the useful reply as solution. Your contribution is highly appreciated.