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

July 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more

Reply
IPerez
Frequent Visitor

Cannot connect to SQL Analysis Service with Dataflow Gen 2

Hello

 

When I setup SQL Analysis Service connection through Enterprise gateway, it works ok, but, when I tryed to create a Dataflow Gen2 using as Data Connector SQL Analysis Service using as connection the one a create beofore or creating a new connection, doesn´t works, I am using the sames credential. The message that I get is:

 

An exception occurred: Received error payload from gateway service with ID 298479: Internal error: MashupCredential for AS data source that uses Windows authentication needs to have an effective user name authentication property. (Session ID: 61e5eca6-e711-4bde-b89d-4d5e48dfe567, Region: us)

 

Does anyone could help me please?

2 REPLIES 2
IPerez
Frequent Visitor

Thank you for your answer, I review de user, i set up the effective user name, etc, but I doesn´t work. If I taste the coneeciton through the garteway, the connection is online, but in DF Gen2  I got the same error message the I mentioned in my original message.

 

Regards

GilbertQ
Super User
Super User

Hi @IPerez 


From the error it appears that you need to map through your email address to log in?





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

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
FabCon and SQLCon Barcelona 2026

FabCon & SQLCon – Barcelona 2026

Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.

60 days of Data Days Carousel

Data Days 2026

Join Fabric Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.