Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
darshp1
Regular Visitor

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

4 REPLIES 4
v-frfei-msft
Community Support
Community Support

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.

 

Support Ticket.gif

 

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

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.

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

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

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

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

March 2024 PBI Gallery Image

Power BI Monthly Update - March 2024

Check out the March 2024 Power BI update to learn about new features.

Top Solution Authors
Top Kudoed Authors