Creation of Gateway connection using MFA

[Somu1234]

Hi All,

I need to create a gateway connection to Mysql DB. Is it possible to create a connection with Multi-Factor authentication in PowerBi services.

Thanks,

Soma

[Somu1234]

Thank you @rohit1991 

[rohit1991 · Accepted solution]

Hi @Somu1234 ,

Hi Soma,

Yes, it is possible to create a gateway connection to a MySQL database in Power BI Service, but currently, Power BI does not natively support Multi-Factor Authentication (MFA) directly for MySQL data sources through the On-Premises Data Gateway. 

MFA is typically enforced at the identity provider level (e.g., Azure AD) rather than the database connection itself. For MySQL, the gateway connects using stored credentials (username and password), which are encrypted and managed within the gateway. If you're looking to enhance security, you may consider using other options such as connecting through Azure services with managed identities or setting up VPN/IP restrictions and strong database authentication policies.

Passionate about leveraging data analytics to drive strategic decision-making and foster business growth.

Connect with me on LinkedIn: Rohit Kumar