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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors
Top Kudoed Authors