SQL SERVER data -> can we have data from 2 SQL SERVERS, using SQL SERVER and MFA authentication

[gulerana21]

can we have data from 2 SQL SERVERS in our Power BI report, one using SQL SERVER authentication and MFA. I am having issue when trying to published to service. My source credentials are greyed out. I checked by publishing with one source and my report with data from SQL SERVER with MFA is working fine but my report with data from sql server with sql server authentication, the source credentials are still greyed out and I can't set up scheduled refresh?

[Anonymous]

Hi @gulerana21 ,

You need to create connections for both SQL Servers.

Add or remove a gateway data source - Power BI | Microsoft Learn

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

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

[lbendlin]

Please provide more details. Where are the credentials greyed out?