Dataflow - Time Out Problem In Oracle Database

[Anonymous]

I have done a Oracle Database Connection on Dataflow but the parameter of Time out is not working properly. I set my time out on 15 minutes but as the images attached below, the dataflow keep running anyway, until someone cancel the query, see:

My queries are like that:

let
Origem = Oracle.Database("XXX.XXX.XXX.XXX", [CommandTimeout = #duration(0, 0, 15, 0),ConnectionTimeout=#duration(0, 0, 15, 0), Query = "SELECT#(lf)#(lf)CODMOD, CODDER, AVG (PRDQTD) AS ""PRDQTD""#(lf)#(lf)FROM#(lf)#(lf)E700CTM#(lf)#(lf)GROUP BY CODMOD, CODDER", HierarchicalNavigation = true])
in
Origem

Do someone know how to solve that? I need that this query just stop and give me the error after the time specified.

[Anonymous]

Hi , @Anonymous 

It's a bit difficult for me to restore your scene, maybe you can raise a Support ticket for help .

Based on the above information, if you are a Power BI Pro licensee, you can create a support ticket for free and a dedicated Microsoft engineer will come to solve the problem for you.

It would be great if you continue to share in this issue to help others with similar problems after you know the root cause or solution.

The link of Power BI Support: https://powerbi.microsoft.com/en-us/support/

For how to create a support ticket, please refer to https://community.powerbi.com/t5/Community-Blog/How-to-create-a-support-ticket-in-Power-BI/ba-p/6830...

Best Regards,
Community Support Team _ Ailsa Tao