Forum Discussion
There was an error when processing the data in the dataset
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
Anonymous
By the way, you may help accept the useful reply as solution. Your contribution is highly appreciated.
4 Replies
- AnonymousNot applicable
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
- AnonymousNot applicable
Anonymous Thanks, let me check, i will come back to you if it's working
- v-chuncz-msft
Community Support
Anonymous
By the way, you may help accept the useful reply as solution. Your contribution is highly appreciated.
- Syndicate_Admin
Administrator
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.