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]