Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

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 @Anonymous ,

 

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.