Ive got a strange problem with refreshing data. Im using PowerBi to connect GCP (MySQL).
The same query executed in mysql workbench is finished in 2-3 seconds, but the same query shared in cloud is timeouting almost always.
90% of executing time in PowerBi is taken by "waiting for server..." step.
- Fitting queries
- Changing setting with IT support
Actually server parameters are upgraded and problem is not existing, but this not solving problem why the same query is execiuted fast on workbench but takes much time in cloud.