Error with Data Refresh and Gateway Configuration After Publishing PBIX File to Power BI Service

Hi Jasleen_kaur ,

The error you're encountering suggests that the MySql.Data.MySqlClient library is not found. This is typically due to the .NET Data Provider for MySQL not being installed or not registered correctly on the machine where the gateway is running. To resolve this:
1.Ensure that the MySQL Connector/Net is installed on the gateway machine.
It may be necessary to install a specific version of the connector that is compatible with your Power BI version. For instance, some users have found success with version 8.0.28.
2.After installation, restart the gateway service and attempt the data refresh again.

For more details, please refer: powerbi - Power BI missing MySQL Connector, even though I installed it 

Best Regards,

Neeko Tang

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