Forum Discussion
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
- mwegenerMost 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.