Hi all, I've installed a powerBI gateway in a microsfot server 2019 and mysql .net version (everything in the latest version). My problem comes when i try to refresh the powerBI from cloud, i get...
v-cazheng-msft
Community Support
Community SupportStatus changed:
New
to Investigating
Hi BYHOURS ,
May I know whether your MySQL database and your on-premises data gateway are installed on the same machines? You mean if you just refresh a simple dataset and with your gateway, there was nothing wrong with it, right? Could you please try these steps?
1 If these two applications are on different machines, please install Desktop on the machine that installs gateway and try if it could connect to your MySQL database from there
2 Prolong the timeout in MySQL connection window popped in Power BI Desktop
3 Remove some unnecessary data from your model and use some filters to reduce the data amount to accelerate the queries
Best Regards,
Community Support Team _ Caiyun