Forum Discussion
ODBC query in dataflow using blank query
Hi guys,
I need help with my connection's dataflow, I am following the stage:
Open Power BI desktop, so copy query of language M and paste on blank query of data flow, but the data base is very large and it takes about 1h:30min to update.
My question is the following:
How can I increase the timeout?
My connection of powerBI desktop is with ODBC
My database is PostgreSQL
I tried use in dataflow, the following code, but it doesn't work
let
Fonte = Odbc.Query("my dns", "my select",[CommandTimeout=#duration(0,2,0,0)])
in
Fonte
4 Replies
"it doesn't work" - please be more specific. What is the error message?
the error message that appears is the "the operation is timed out", after running with 10 minutes.
There are two possibilities that I see. Either the ODBC.Query command ignores your CommandTimeout setting (rather unlikely) or your data source (Postgres) ignores it and imposes their own. Maybe talk to the database admin to get their opinion. Do you get the same issue when connecting with a thin client (the equivalent of SSMS)?
No, I don't, when I connect with SQL manager for PostgreSQL and running the query I don't have problem, the same thing in the Power BI desktop, but in the data flow it doesn't work, with samll database works
