Issue with Loading Data from MySQL Database in Power BI

Dear Power BI Support,

I hope this message finds you well. I am writing to seek assistance with an issue I am encountering while loading data from a MySQL database into Power BI online. I have encountered the following error:

Activity ID: c32d65fb-5643-bdf6-b537-5256be4a8182
Request ID: d14567fa-64dd-4999-8789-68ff8b7df148
Status code: 500
Error Code: OperationCanceled
Batch ID: 464e8dc5-ff11-40b4-b1b1-f6a20f46dc1c@c7b9ada0-1291-4c2d-bf9b-bae6ac1e1f06$2023-07-11T15:16:03.6641366Z@f4d9d83e-2531-410c-8d38-cf541c657b87

I have been unable to resolve this issue on my own, despite attempting various troubleshooting steps. Here is a brief description of the problem and the steps I have taken:

Description:
I am trying to load data from a MySQL database into Power BI. However, during the data loading process, I consistently encounter the aforementioned error. This error prevents me from successfully importing the data into Power BI and analyzing it.

Troubleshooting Steps Taken:
1. Checked the database connection: I have verified that the connection details (server address, port, username, password) are correct and that I can successfully connect to the MySQL database using these credentials outside of Power BI.

Given the persisting issue and my unsuccessful attempts to resolve it, I kindly request your assistance in identifying the cause of the error and finding a solution. The provided error codes and IDs should help in investigating the issue more effectively.

If any additional information or diagnostic data is required, please let me know, and I will be happy to provide it. I appreciate your prompt attention to this matter and look forward to your support in resolving this issue.

Thank you for your time and assistance.

Best regards,
Razak

[email protected]