Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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

  • Anonymous's avatar
    Anonymous
    Not 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

    • Anonymous's avatar
      Anonymous
      Not applicable

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

      • v-chuncz-msft's avatar
        v-chuncz-msft
        Icon for Community Support rankCommunity Support

        Anonymous 

         

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

  • 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.