Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Razak
New Member

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

Razak@digitalgreen.org

 

1 REPLY 1
lbendlin
Super User
Super User

what's the MySQl driver version?

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.