Forum Discussion

Alex_Ooi's avatar
Alex_Ooi
Helper IV
6 years ago
Solved

PostgreSQL Timeout Error

Hi,   I need your expert advice and possible workarounds that are not too manual for the timeout error I encounter every time I query my dB in PostgreSQL. This is the same type of error appearing i...
Need Help
  • v-xuding-msft's avatar
    v-xuding-msft
    6 years ago

    Hi Alex_Ooi ,

    Maybe you could reference the ways to change timeout parameters to check if you could connect the data source without an error. 

     

    1. Add timeout parameter to connection string:

    • Connect Timeout=xx  (xx = seconds)

    2. Otherwise, you could add  timeout parameter to Query argument within M Code / Advanced Editor:

    • let
      Source =
      Odbc.DataSource(
      xxxxxxxxxxxxxxxxx,
      [Query = "xxxxxxxxx",CommandTimeout =#duration(0,1,0,0)]
      )
      in
      Source 

     

    Reference:

    https://docs.microsoft.com/en-us/powerquery-m/odbc-datasource

     

    Best Regards,

    Xue Ding

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

mwegener's avatar
mwegener
Most Valuable Professional
6 years ago

Hi Alex_Ooi ,

 

did you try to increase the timeout?

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.

Alex_Ooi's avatar
Alex_Ooi
Helper IV
6 years ago

Hi mwegener there are issues with connecting directly with PostgreSQL (query folding). Discussion thread here: https://community.powerbi.com/t5/Desktop/Query-Folding-disable/m-p/873976#M419092

 

As such, I connected using ODBC which does not allow me to change timeout.

 

I am afraid the only way to do this is to query by batch and merge query later. But I am concerned about the optimisation since I don't have Premium to do incremental refresh.