Forum Discussion

OneWithQuestion's avatar
OneWithQuestion
Icon for Post Prodigy rankPost Prodigy
6 years ago

Data Gateway login error unexpected using local machine's credentials to connect?

I am using the data gateway with Azure Analysis Services and I was running a data refresh that failed due to there being insufficient memory available in the Azure AS service (which is fine, I just needed to upsize).

 

Anyway, what is odd is that during the data refresh attempt it was connecting using the proper connection string specified in the model's connection property.

so the line in the logs shows:

[DataMovement.PipeLine.GatewayDataAccess] RawOledbConnectionString: Impersonating <pi>mydomian\UserName</pi>

 

then the next line

 

[code[

DM.EnterpriseGateway Warning: 0 : ....DM.EnterpriseGateway .... [DM.GatewayCore] Swallowing exception during processing of OleDbCreateRowsetRequest attempt #1 and triggering a retry: System.Runtime.InteropServices.COMException (0x80004005): Login failed for user 'domain\NameOfServerRunningGateway-DEV$'.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
at Microsoft.PowerBI.DataMovement.Pipeline.OleDbBase.IDBCreateSessionExtensions.CreateSession(IDBCreateSession dbCreateSession)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.OleDbRequestSessionStateless.get_AdhocSession()
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.OleDbRequestSessionStateless.get_DBCreateCommand()
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.OleDbProcessor.<>c__DisplayClass4_0.<ExecuteOleDbQuery>b__1(IOleDbRequestSession requestSession)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.OleDbProcessor.ProcessRequest[TRequest](GatewaySerializationContext serverContext, TRequest request, OleDbInternalErrorKind errorKind, Func`2 operation, Action`1 onOperationFailure, Guid requestId)

 

 

[/code]

 

 

I really have no idea what is causing this.

 

Additionally, I tried running the data refresh where it failed again but I never encountered the gateway trying to login again with the local machine's credentials.

Need Help

4 Replies

  • GilbertQ's avatar
    GilbertQ
    Icon for Super User rankSuper User
    6 years ago
    Hi there

    Are you importing data from AAS into your PBIX or just querying using LiveConnection?
    • OneWithQuestion's avatar
      OneWithQuestion
      Icon for Post Prodigy rankPost Prodigy
      6 years ago

      I have PBI connected to AAS as a live data connection.

       

      The issue crops up when Azure Analysis Services does a data refresh, the enterprise gateway AAS is using will try to connect to the SQL data source using the account the gateway service is running under, NOT as the account the connection string in AAS data model specifies to use.

       

      It is odd.

      • GilbertQ's avatar
        GilbertQ
        Icon for Super User rankSuper User
        6 years ago
        Hi there

        How have you configured your AAS Connection to your data source?

        Do you have the SSO enabled on the data source?
  • venal's avatar
    venal
    Icon for Memorable Member rankMemorable Member
    6 years ago

    OneWithQuestion 

    Is the Gateway is latest version?

    If not, please upgrade to the latest version with the below link.

     

    https://www.microsoft.com/en-us/download/details.aspx?id=53127

     

    Enable the below settings in Power BI Service >> Settings >> Manage Gateways.

     

    After upgrading the GW to latest version, if the issue is persists. Please submit a support ticket to investigate it in AAS and Power BI.

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more
    If this post was helpful may I ask you to mark it as solution and click on thumb symbol?

     

    BR

    venal.