Forum Discussion

darshp1's avatar
darshp1
Regular Visitor
7 years ago

PowerBI Gateway Fails to sync with MySQL

I have had a power bi gateway running smoothly for a few months but in the last few weeks the scheduled or on demand refresh fails every time.  I have checked MySQL (version, settings, etc), reinstalled the gateway, tried another machine but I am having no luck. 

 

Online it just shows "Refresh in progress" for about an hour and then says it failed.

 

Today I pulled the logs off the gateway and found this:

 

DM.EnterpriseGateway Error: 0 : 2019-01-24T05:07:32.8757916Z DM.EnterpriseGateway    00000000-0000-0000-0000-000000000000    00000000-0000-0000-0000-000000000000    0000    00000000-0000-0000-0000-000000000000    53D65D6E [DM.Analytics] Performance counters not installed, application performance metrics will not be traced (category = Performance counters specific to the on-premises data gateway)

 

DM.EnterpriseGateway Error: 0 : 2019-01-25T18:14:35.3253866Z DM.EnterpriseGateway    69463dd8-a7d1-4782-9a20-0e4f90364926    df0a4f8a-490f-073c-d27c-438204dbb1da    MGSR    5ebc8042-4e33-4520-82b9-d4e1e9e6781b    34F2C06D [DM.Pipeline.Common.TracingTelemetryService] Event: FireActivityCompletedWithFailureEvent (duration=193, err=CommunicationException, rootcauseErrorEventId=0)

 

DM.EnterpriseGateway Error: 0 : 2019-01-25T18:14:35.3253866Z DM.EnterpriseGateway    2d03f287-6d0c-4276-a5ce-02a21ca5491e    df0a4f8a-490f-073c-d27c-438204dbb1da    MGRF    5ebc8042-4e33-4520-82b9-d4e1e9e6781b    C8EBFE52 [DM.Pipeline.Common.TracingTelemetryService] Event: FireActivityCompletedWithFailureEvent (duration=194, err=CommunicationException, rootcauseErrorEventId=0)

 

DM.EnterpriseGateway Error: 0 : 2019-01-25T18:14:35.3273851Z DM.EnterpriseGateway    bf57c708-7ad4-4acb-8c3f-9a5cab51e41e    df0a4f8a-490f-073c-d27c-438204dbb1da    MGST    5ebc8042-4e33-4520-82b9-d4e1e9e6781b    F8FDA0F8 [DM.Pipeline.Common.TracingTelemetryService] Event: FireActivityCompletedWithFailureEvent (duration=4943, err=CommunicationException, rootcauseErrorEventId=0)

 

DM.EnterpriseGateway Error: 0 : 2019-01-25T18:15:05.4186089Z DM.EnterpriseGateway    64cdbc13-f08c-498f-accc-e50e55494f76    df0a4f8a-490f-073c-d27c-438204dbb1da    MGAS    5ebc8042-4e33-4520-82b9-d4e1e9e6781b    5BFD273A [DM.Pipeline.Diagnostics] Exception object created [IsBenign=False]: Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.AsyncOperationStreamingCancelledException: The async operation id f7fa1aa9-61dc-44ca-891f-1be813c322dd streaming was cancelled.; ErrorShortName: AsyncOperationStreamingCancelledException

 

DM.EnterpriseGateway Error: 0 : 2019-01-25T18:15:05.4296013Z DM.EnterpriseGateway    64cdbc13-f08c-498f-accc-e50e55494f76    df0a4f8a-490f-073c-d27c-438204dbb1da    MGAS    5ebc8042-4e33-4520-82b9-d4e1e9e6781b    6BC91D9F [DM.Pipeline.Diagnostics] StackTrace:    at Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.AsyncOperationStreamingCancelledException.TraceConstructor()

 

Any help would be appreciated!!!!

Need Help

4 Replies

  • v-frfei-msft's avatar
    v-frfei-msft
    Community Support
    7 years ago

    Hi darshp1,

     

    Did you try to refresh the report in desktop?

     

    Could you please try to delete the dataset and reconfigure the refresh once again to have a test?

     

    Or you can create a support ticket for help here if you are a pro user.

     

     

    Regards,

    Frank

    • darshp1's avatar
      darshp1
      Regular Visitor
      7 years ago

      I am able to refresh in desktop, but it is just slow.

       

      Have tried to delete and re setup dataset but it fails after resetting it up.

       

      Any other suggestions are appreciated.

       

      I am unfortunately not a pro member yet, this dataset and report were the final test for us.

      • v-frfei-msft's avatar
        v-frfei-msft
        Community Support
        7 years ago

        Hi darshp1 ,

         

        This is a known issue, I will let you know once fixed. Currently, we can only tyr doing on-demand refresh.

         

        Regards,

        Frank