SAP ODBC.DataSource SupportsDerivedTable

Hi pbi_user_rdg ,

According to the official document—— The supported options records fields fall into two categories—

1. Are public and always available. The record can contain the following fields:

HierarchicalNavigation 

CreateNavigationProperties 

ConnectionTimeout 

CommandTimeout 

SqlCompatibleWindowsAuth 

So for example:

Source = Odbc.DataSource("dsn=Test", [ConnectionTimeout=#duration(0,0,10,0)])

2. Are only available in an extensibility context.

Since SupportsDerivedTable option is not public ,it is used in Overriding SqlCapabilities, you could not directly use it.

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