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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Sept PBI Carousel

Power BI Monthly Update - September 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

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

Top Solution Authors