Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Command Timeout in M code in Power Query

Hi

 

Can somebody please assist with syntax when adding a Command Timeout to the source of a (non-native) query imported table?

 

This is the code I am struggling to add the Command timeout to:

let
Source = #"SQL/servername;dbname",
SSAS_V_Income_Statement = Source{[Schema="SSAS",Item="V_Income_Statement"]}[Data]
in
SSAS_V_Income_Statement


I use the following code when adding the Command Timeout to the native query generated table and this works:

let

Source = Sql.Database("servername","dbname",[CommandTimeout=#duration(0, 2, 0, 0)]),
MyQuery =
Value.NativeQuery(
Source,
"


SELECT...... "

2 Replies