Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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 2
v-kelly-msft
Community Support
Community Support

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
Not applicable

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors