MySQL Data - "Evaluating" taking excessive time

Hi Kletzy 

The issue you're facing is slow refresh times in Power BI when connecting to a small table in a MySQL database hosted on Azure especially when the database and the query seem simple,There are several potential factors that could be causing this delay. 

Network Latency:

• Since your database is in Azure and you're likely connecting from a different location, network latency can be a significant factor.
• Test the network latency between your Power BI environment and the Azure server.

Database Server Performance:

• Check the performance metrics of your MySQL database server in Azure.
  Use a performance analysis tool for MySQL, such as MySQL Workbench or other third-party tools, to analyze the performance of your queries.
• Ensure that the server is not under heavy load and has adequate resources.

Query Performance:

• Although your query is simple, it's worth running it directly against the database to see how long it takes.
• Use MySQL’s 'EXPLAIN' statement to see if there are any inefficiencies in how the query is executed.
  

Azure Configuration:

• If you're using a lower tier of Azure's database service, you might experience slower performance. Consider scaling up the database service tier.
• Check if there are any throttling or resource limitation settings in Azure that might affect the performance.

Debugging Approach:

• Try connecting to a different MySQL database (maybe even a local one) and see if the issue persists. This can help determine if the problem is specific to the Azure environment or a broader issue with Power BI’s handling of MySQL databases.

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.