Problem when import from oracle database

[hama21]

Hello guys

I updated some dataflow for incremental update, however, after this change, I can't update the dataflow anymore. I'm getting DM_GWPipeline_Gateway_TimeoutError error. Could anyone help me with this error? Before it loaded normally, sometimes it had a timeout problem, but it refreshed and it was successful. That's why I thought of implementing incremental updating.

I saw in a post to use the CommandTimeout and ConnetionTimeout command, but I couldn't use it with Oracle Database.

Please, anyone can help me?

Thank you

[v-binbinyu-msft]

Hi @hama21 ,
Please add "TimeOut" parameters to connection in the Power Query Pane for DataFlow.

Similar to the ODBC timeout configuration there is also a timeout setting for an Oracle connection (with slightly different syntax).

for example to set the timeout for 2 hours :

Source=Oracle.Database(server as text,CommandTimeout=#duration(0,2,0,0)) as table

Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[hama21]

I've tried that but it didn't work