Forum Discussion

lmelo's avatar
lmelo
Icon for Helper I rankHelper I
5 years ago
Solved

Dashboards not refreshing

I have 6 dashboards which were updating fine for a few months through the service schedule, all conected to the same MySQL db. The gateway is fine, but in the last weeks 2 of the 6 dashboards are not...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    HI lmelo,

    Have you also modify the MashupDisableContainerAutoConfig to enable the custom settings? By default custom setting not auto-enabled. (please also try to restart your gateway client if these setting does not change the current client)

     

    Spoiler

    If you've changed any of these settings manually, automatic scaling is not enabled by default. To enable it, in \Program Files\On-premises data gateway\Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.dll.config set MashupDisableContainerAutoConfig to False.

    Regards,
    Xiaoxin Sheng

     

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
5 years ago

When you say dashboards you mean reports, right?

 

How many concurrent connections can your MySQL db handle?  Try disabling parallel load of data sources to see if it makes a difference.

  • lmelo's avatar
    lmelo
    Icon for Helper I rankHelper I
    5 years ago

    Yes, sorry, I mean reports. How can I disable this parallel load you're talking? Thanks.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      HI lmelo,

      How long did these refreshes spend? Did these exceed the refresh timeout(2 hours)? For the parallel loading option, you can find it in option -> data load.


      Regards,

      Xiaoxin Sheng

      • lmelo's avatar
        lmelo
        Icon for Helper I rankHelper I
        5 years ago

        It just take a few seconds to update the tables. I found the option to disable parallel loading now, thanks! It works on desktop, I think you're right in this was the cause of the problem. But on the service (web), I tryed to manually click on "update now" and the problem persists. Is there anyway to disable parallel loading on the service too, or just on the desktop? Thanks!