Command timeout in minutes is grayed out

If the "Command timeout in minutes (optional)" input field is disabled, it is because one or more tables have table-specific timeout values that are unique. This field is only editable globally via the Data Source Settings if all tables have identical timeouts.

To fix this:

1. Click "Transform Data" from the toolbar menu

2. For each table click on the table name and then click "Advanced Editor" from the toolbar menu

3. The dialog box that is shown should contain:

Source = Sql.Database("my-database-server.database.windows.net", "my-database"),

4. If the dialog box contains a custom timeout value (such as below), you can remove it (or ensure that it is configured consistently for all tables in the report)

Source = Sql.Database("my-database-server.database.windows.net", "my-database", [CommandTimeout=#duration(0, 0, 30, 0)]),

The four parameters for the #duration definition are days, hours, minutes, and seconds. The above example sets the timeout to 30 minutes.

5. If the timeout setting is removed, or is identical for all tables, then the "Command timeout in minutes (optional)" value will be editable and will reflect the configured value for all tables (i.e. 30 minutes).

Hi Anonymous ,

You could try to add specify timeout interval in Advanced Editor manually. See the image below. Hope it will help you.

[CommandTimeout=#duration(0, 0, 30, 0)])

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.