Odbc.DataSource

This function retrieves a list of SQL tables and views from the ODBC data source defined by the connection string specified in the connectionString parameter. The connectionString can be either a text string or a collection of key-value pairs. The values in the key-value pairs can be either text or numerical. An optional parameter called options can be provided in the form of a collection to specify additional settings. The options collection can include the following fields: - CreateNavigationProperties: A boolean value (true/false) that indicates whether navigation properties should be generated for the returned values. The default setting is true. - HierarchicalNavigation: A boolean value (true/false) that determines whether tables should be grouped by their schema names. The default setting is false. - ConnectionTimeout: A duration value that sets the maximum time to wait before abandoning a connection attempt to the server. The default duration is 15 seconds. - CommandTimeout: A duration value that set

Retrieve the SQL tables and views using the connection string provided. Syntax: Power Query M Odbc.DataSource("dsn=your_dsn") Result: Power Query Mtable