Power Query Problems

Fix Missing MySQL Rows When Refreshing Excel 2019 for Mac

Maira MehtabMaira Mehtab Nov 22, 2026 868 views

Question details

The user needs an Excel 2019 for Mac query to show all current rows from a MySQL database.

Fix Missing MySQL Rows When Refreshing Excel 2019 for Mac
Product
Microsoft Excel 2019 for Mac and MySQL
Device & OS
Mac, macOS version not provided
Scenario
A workbook uses a MySQL query to retrieve records from a database that receives regular updates.
Observed behavior
The query displays only a few rows, and refreshing it may not show newly added records.
Before you start

Confirm which database, table, and query the workbook uses, and check that you can view the source records in a MySQL client. Note your macOS and Excel version numbers in case you need to report the issue.

Solution 1Recommended

Test the MySQL connection with a new sample database

Use a small test database to determine whether the missing rows can be reproduced outside the original data source.

1
Create sample records

In your MySQL client, create a test database and table with more than three rows. Use non-sensitive sample data.

2
Check the source rows

Run a SELECT statement against the test table in your MySQL client and confirm that it returns every sample row.

3
Test the connection in Excel

Use the same connection method to query the test table in Excel, then use the available Refresh command on the result and compare the displayed rows with the MySQL results.

4
Collect version details

If the test also misses rows, open About This Mac from the Apple menu and About Excel from the Excel menu. Include those version details and the test results when requesting support.

Test the MySQL connection with a new sample database
Protect connection details: Do not publish database credentials or other sensitive connection information when sharing the results.
Free Microsoft Office alternative

Review MySQL Export Data in WPS Spreadsheets

WPS Office is a free, lightweight Office alternative with a familiar interface for reviewing spreadsheet data. Open a MySQL export in WPS Spreadsheets or move compatible workbooks from Excel; WPS does not repair Excel's MySQL refresh connection.

Review MySQL data exported to a CSV fileOpen and edit Microsoft Excel XLSX and XLS filesUse a familiar spreadsheet interface for an easier transition from ExcelWork with a free, lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Why does my MySQL query show fewer rows in Excel?

A SQL LIMIT or WHERE condition, an Excel result filter, or a connection issue may be involved. Run the same SQL in a MySQL client and compare the results with Excel.

How can I tell whether the database is causing the problem?

Create a test database with more than three sample rows, verify them with a SELECT statement in a MySQL client, and query it through the same Excel connection method. Compare the results to see whether the issue also occurs with the test data.

Where can I find my macOS and Excel versions?

Choose About This Mac from the Apple menu for the macOS version, and choose About Excel from the Excel menu for the Office version.

Can WPS Office fix Excel's MySQL refresh connection?

No. WPS Office is an alternative for working with spreadsheet files, not a repair for Excel's connection. You can export MySQL data to CSV and open it in WPS Spreadsheets for review.