Forum Discussion

IPerez's avatar
IPerez
Frequent Visitor
2 years ago

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?

Dataflow

2 Replies

  • GilbertQ's avatar
    GilbertQ
    Super User
    2 years ago

    Hi IPerez 


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

  • IPerez's avatar
    IPerez
    Frequent Visitor
    2 years ago

    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