Forum Discussion
not able to connect MySQL with PowerBi
i am not able to connect my sql with power bi , it shows an error when i try to connect. i am attaching a screenshot below .
Can anyone please help me to resolve this issue. Also i have changed my max_use
1 Reply
You installed MySQL server on the same PC you are running Power BI on. That MySQL server is configured to allow 5 connections. They are all consumed.
Recommendation is to install MySQL on a dedicated server and increase the connection pool substantially.
