Forum Discussion
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 updating, presenting the error "MySQL: Unable to connect to any of the specified MySQL hosts."
I though it was odd that the error occur just in two of them. I tryed to update one of them manually, on desktop, which have several tables. When I click on the buttom "Update" in the main menu (the one right next to "transform data"), one of the tables has the same error: "MySQL: Unable to connect to any of the specified MySQL hosts." and the rest presents "MySQL: Fatal error encountered during command execution."
But here is the REALLY odd thing: whem I try to update each table separately, it just works fine. I tryed to conected manually to database, works fine.
Doesn anybody has any idea what's going on? Tks.
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)
SpoilerIf 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
MashupDisableContainerAutoConfigto False.Regards,
Xiaoxin Sheng
9 Replies
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.
