cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
anikah
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:

anikah_1-1686348605625.png

 

Thanks in advance

 

 

 

1 REPLY 1
collinq
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

Announcements
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