Forum Discussion

visheshjain's avatar
visheshjain
Icon for Impactful Individual rankImpactful Individual
9 months ago
Solved

Error in refresh on service using MySQL RDS data source

Hello everyone,   My data source is MySQL hosted on AWS RDS, for all my tables. There are 2 main tables, 1 with 6.8 million rows and another with 2.5 million rows, amongst few other small tables w...
Need Help
Show and Tell
Tips and Tricks
  • visheshjain's avatar
    visheshjain
    8 months ago

    Hi Anonymous & collinq 

    Thank you for taking the time to respond to the issue.

     

    So the gateway has been configured properly and the refresh has worked, but with minor tweaks to your suggested solutions.

     

    Here are my findings and if anyone would like to add more then I'm all ears.

     

    1. The 'Personal Cloud Connect' where a gateway is not required for the refresh, will probably work for small datasets but not a full fledged report. (This is my experience and I would like to hear any suggestions on how to eliminate the gateway WITHOUT COMPROMISING SECURITY)

     

    2. Using the gateway works but you have to install a MySQL connector on the machine with the gateway, so that the gateway knows how to talk to the SQL server.

     

    3. For MySQL install the .Net 8.4 connector and not the latest (as of Jan 2026) 9.0 connector.

     

    4. Make sure you have only 1 MySQL connector installed, cause if 2 connectors are installed, the gateway might not know which one to use.

     

    I hope this helps anyone else with the same issues.

     

    Thank you,

    Vishesh Jain

visheshjain's avatar
visheshjain
Icon for Impactful Individual rankImpactful Individual
9 months ago

Hi collinq,

 

This is my configuration in the PBI service for the data source and I have entered the credentials in the 'Data Source Credentials' tab.

 

I tried something else; I removed all the tables except for the 6.8 million rows table and published it to the service with the same configuration and the refresh worked.

 

Are there any other suggestions that might be useful, apart from using a gateway?

 

Thank you,

Vishesh Jain

Anonymous's avatar
Anonymous
Not applicable
9 months ago

Hi visheshjain ,

You need to install the Oracle MySQL Connector/NET package before using this connector in Power BI Desktop. For Power Query Online (dataflows) or Power BI service, if your MySQL server isn't cloud accessible and an on-premises data gateway is needed, the component Oracle MySQL Connector/NET must also be correctly installed on the machine running the on-premises data gateway.

 

Power Query MySQL database connector - Power Query | Microsoft Learn

 

I hope this information helps. Please do let us know if you have any further queries.
Thank you