Forum Discussion

FurkanSa's avatar
FurkanSa
Frequent Visitor
1 year ago
Solved

Onprem PostgreSql to Lakehouse connection error

Hello Data Fam, A while ago, I was building a data warehouse by connecting to PostgreSQL through a Data Pipeline, then transferring data to a Lakehouse and from there to the Data Warehouse. It w...
Pipeline
jennratten's avatar
jennratten
Icon for Super User rankSuper User
1 year ago

There could be many possible causes here.  I recommend running a few other tests using something similar to the sample script below with the point being to query a very small amount of data using the same data source connection that is in question as well as one other that's on the same gateway.  This will help narrow down the possibilities.

  • Does it work in a new data pipeline?
  • Does it work in a different workspace?
  • Does a similar small query work in a data pipeline for another data source that is on the same gateway?
  • Does it work in a dataflow gen2?
  • Additional Info:
    • Has the gateway version been updated in the last 5-7 months?  
    • What is the version of the gateway app?

Sample Script

SELECT *
FROM your_table_name
LIMIT 1;

 

Translated Error Message:

Error Details

Source to Silver - dimordertype

  • Error Code: 2200
  • Error Type: User configuration issue

Details:

  • Type=Npgsql.NpgsqlException: Exception while reading from stream (Source: Npgsql)
  • Type=System.TimeoutException: Timeout during reading attempt

Event ID: 32f30420-ffe9-49e7-98bf-523ae12f9011

 

FurkanSa's avatar
FurkanSa
Frequent Visitor
1 year ago

Thanks for all the suggestions, but I'm still facing the same issue. 😕

I’ve tried creating a new data pipeline, switching to different workspaces, using smaller queries, and even testing with Dataflow Gen2 — but none of these worked.

The gateway app version is June 2025. I updated it (previously it was May 2025), thinking it might resolve the issue, but unfortunately, it didn’t help.

We have several reports using the same gateway with different data sources, and those are working fine. The issue only occurs when trying to connect to PostgreSQL.

I can successfully access the PostgreSQL server directly, but the gateway cannot. Everything was working fine a few weeks ago — but now the connection fails.

  • jennratten's avatar
    jennratten
    Icon for Super User rankSuper User
    1 year ago

    Thanks for running those tests.  Based on your findings this could be a network/firewall issue, if any rules were changed with the Azure infrastructure.  That would be the next step to check.  Aside from that I recommend submitting a support ticket with Microsoft for deeper assistance.

    • FurkanSa's avatar
      FurkanSa
      Frequent Visitor
      1 year ago

      Thank you very much. I attempted to open a Microsoft support ticket, but it appears that our company's contract does not include this service. Do you know of any alternative ways to reach support?

      • Anonymous's avatar
        Anonymous
        Not applicable
        1 year ago

        Hi FurkanSa,

        As none of the above helped, at this point it was worth it to open a support ticket with Microsoft. You can reach out to Microsoft Support by raising a ticket with Microsoft Support. Please refer below link on how to raise a contact support or support ticket.
        How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

         

        Best Regards,

        Hammad.