Based on the issue that you mentioned, I have made a test on my side, and don't have the issue that you mentioned. Please make sure you have installed proper version of MySQL server on your PC, which matches your Power BI Desktop installation (32-bit or 64-bit).
Please check the following thread or article for more details:
Also please check if you have shaped your MYSQL Table records before loading into your Power BI Desktop. If you have installed MYSQL workbench client in your PC, please use it to connect to your MYSQL Server, then check if the corresponding Table is populated with proper records.
If the issue still exists, please consider re-GetData from your MYSQL Table into your app, check if the issue is solved.
Community Support Team _ Kris Dai If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.