PowerBI Gateway Fails to sync with MySQL

[darshp1]

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!!!!

[v-frfei-msft]

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]

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]

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

[darshp1]

Just checking in to see if there is a fix for this yet?