Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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...... "
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!
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" ...