Showing results for 
Search instead for 
Did you mean: 
Helper II
Helper II

PBI cloud datasets can connect to AD universal MFA?

Hello All,


The connection to the synapse analytics uses AD Universal MFA as the authentication method, and I am able to successfully connect to Synapse using SSMS and Power BI Desktop. However, I am unable to refresh the published PBI dataset, which is pointing to Synapse, on power BI services with auth2 connection.

For Power BI gateway setup we have only 2 types supported i.e. Basic and OAuth.

What type of connection authentication needs to be created for Synapse and Power BI cloud?

Error Message:



Thanks in advance




Super User
Super User

Hi @anikah ,


You can't have MFA set on a userid that is doing automatic refresh.  Therefore, the best way around this is to have a service account or other account that does not require MFA and then the automatic refresh will work fine.  This is more the issue that I think you are encountering than the type of connection.

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors
Top Kudoed Authors