Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Expression.Error: 3 arguments were passed to a function which expects between 1 and 2. in timeout

Hey all, 

 

I am receiving the following error message: 

"Refresh Failed: Oracle: ORA-01013: user requested cancel of current operation"

I have found a solution online to set the timeout value higher in the query editor using the syntax: 

[timeout=#duration(0,0,30,0)]))

In my case the data source is oracle database and my query in the power query editor looks like this: 

let
Source = Oracle.Database("XY", [HierarchicalNavigation=true],[timeout=#duration(0,0,30,0)])
FDE = Source{[Schema="FDE"]}[Data],
VW_RATES = FDE{[Name="VW_RATES"]}[Data]
in
VW_RATES

 

but now I receive the following error message: 

"Expression.Error: 3 arguments were passed to a function which expects between 1 and 2."

What am I doing wrong? Can you help me formulate the timeout setting for my purpose?

 

Thanks for your help and Kind regards

Susanne

 

 

  • Hi Anonymous ,

     

    try to set the timeout via the dialog.

     

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

    Please give Kudos for support.

1 Reply

  • mwegener's avatar
    mwegener
    Most Valuable Professional

    Hi Anonymous ,

     

    try to set the timeout via the dialog.

     

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

    Please give Kudos for support.