Forum Discussion

Uzi2019's avatar
Uzi2019
Community Champion
7 months ago
Solved

MYSQL cloud database gateway setup

Hey Experts, I need some help understanding an issue with Power BI refresh setup. I have two databases: SQL Server installed on a separate RDP/VM, where the Power BI On-Premises Gatewa...
Need Help
  • Tahreem24's avatar
    Tahreem24
    7 months ago

    Uzi2019 ,

     

    This issue usually occurs due to firewall rules, network security, and encryption settings on the cloud-hosted MySQL database.
    Even though the database is hosted on AWS, Power BI Service cannot directly connect to it in many cases because:
    The MySQL instance is behind VPC / firewall restrictions
    SSL / encryption settings are enforced
    Power BI Service IPs are not allowed in the database security group
    Recommended Solution:
    Create an intermediate VM/RDP instance(for example, on AWS or your internal network).
    Ensure this VM has network access to the MySQL cloud database (via firewall rules, VPN, or security group configuration).
    Install the latest version of the Power BI On-Premises Data Gateway on this RDP/VM.
    Configure the MySQL data source in Power BI Service to use this gateway connection.
    Once Power BI Service connects to the MySQL database through the gateway, the refresh works without issues.

    I faced the same issue, and this approach successfully resolved it.

     

     

Tahreem24's avatar
Tahreem24
Super User
7 months ago

Uzi2019 ,

 

This issue usually occurs due to firewall rules, network security, and encryption settings on the cloud-hosted MySQL database.
Even though the database is hosted on AWS, Power BI Service cannot directly connect to it in many cases because:
The MySQL instance is behind VPC / firewall restrictions
SSL / encryption settings are enforced
Power BI Service IPs are not allowed in the database security group
Recommended Solution:
Create an intermediate VM/RDP instance(for example, on AWS or your internal network).
Ensure this VM has network access to the MySQL cloud database (via firewall rules, VPN, or security group configuration).
Install the latest version of the Power BI On-Premises Data Gateway on this RDP/VM.
Configure the MySQL data source in Power BI Service to use this gateway connection.
Once Power BI Service connects to the MySQL database through the gateway, the refresh works without issues.

I faced the same issue, and this approach successfully resolved it.

 

 

  • Uzi2019's avatar
    Uzi2019
    Community Champion
    7 months ago

    HI Tahreem24 

    Thank you for your quick response. Appreciate your help.

     

    Our network support team have also suggested similar approach. That's why checking on community for confirmation.