Command Timeout in M code in Power Query

[Anonymous]

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...... "

[v-kelly-msft]

Hi  @Anonymous ,

Check the similar thread  below:

https://community.powerbi.com/t5/Desktop/How-to-set-command-timeout-option/m-p/487941

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[Anonymous]

hi Kelly

Thank you for the response.

I tried using the SQL.DATABASES function/prefix, but that did not work.

So my problem remains adding the timeout to this part #"SQL/servername;dbname" ...