Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Not able to connect with Azure Synapse

Hi Team, 

 

i am not able to connect to PBI Services to Azure Synapse data base using Gateway connection. getting multiple errors with refresh the data. 

i am using Visual Studio to create the data model and deploy the metedata to PBI services and establish the connectivity to synapse, and that was successful. 

But while refersh the data set from PBI services, am getting errors like 

Timeout, and 

 

Data source error: Received error payload from gateway service with ID 281616: Async operation 3240d0f5-ce2a-49f1-af7b-7bb7ba340e02 is faulted with [0]Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.MashupDataAccessValueException: Mashup expression evaluation error. Reason: .

GatewayPipelineErrorCode=DM_GWPipeline_Gateway_MashupDataAccessError

GatewayVersion=3000.110.5

Reason= --->

[1]Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.GatewayPipelineWrapperException: Substituted: MashupValueException:Microsoft.Data.Mashup.MashupValueException (0x80004005): Microsoft SQL: Connection Timeout Expired.  The timeout period elapsed during the post-login phase.  The connection could have timed out while waiting for server to complete the login process and respond; Or it could have timed out while attempting to create multiple active connections.  The duration spent while attempting to connect to this server was - [Pre-Login] initialization=36; handshake=74; [Login] initialization=7; authentication=5; [Post-Login] complete=29780; ....................

 

 

Data source error: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"Microsoft SQL: Database 'depweusqlpool' on server '' is not currently available.  Please retry the connection later.  If the problem persists, contact customer support, and provide them the session tracing ID of '{B119F362-0573-4962-9B94-13703BA7B653}'."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"- .......................................

 

 

this is UAT serverpool. so can anyone help me

 

thanks in advance 

 

Need Help

2 Replies

  • v-zhangti's avatar
    v-zhangti
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi, Anonymous 

     

    First of all, you should always ensure that basic requirements for refresh are met and verified. These basic requirements include:

    • Verify the gateway version is up to date
    • Verify the report has a gateway selected - if not, the datasource may have changed or might be missing

    Scheduled refresh for imported datasets timeout after two hours. This timeout is increased to five hours for datasets in Premium workspaces. If you encounter this limit, consider reducing the size or complexity of your dataset, or consider refactoring the large dataset into multiple smaller datasets.

     

    This error can occur because of expired cached credentials. Clear your internet browser cache by going signing into Power BI and going to https://app.powerbi.com?alwaysPromptForContentProviderCreds=true  This forces an update of your credentials.

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more.

  • learner03's avatar
    learner03
    Icon for Post Partisan rankPost Partisan
    4 years ago

    Anonymous I am getting similar sort of errors too since half n hour-

    Failure details: The last refresh attempt failed because of an internal service error. This is usually a transient issue. If you try again later and still see this message, contact support.
    And even getting below on the service page-

    But there doesn't seen any reports/issues on the power bi service status page.