Sql.Database

Returns a table containing SQL tables located on a SQL Server instance database.

Sql.Database(server as text, database as text, optional options as nullable record) as record

Arguments

Argument Description
server The name of the SQL Server instance.
datab The database in the SQL Server instance.
optional options An options record to control the behavior of this function.

options Settings

Setting Description
MaxDegreeOfParallelism as number or integer Sets the value of the "maxdop” query clause in the generated SQL query.
CreateNavigationProperties as logical Sets whether to generate navigation properties on the returned values. Default is true.
NavigationPropertyNameGenerator as function Provides a function that is used for the creation of names for navigation properties.

Example

Sql.Database("localhost", "Northwind")

 
 
Applies to:
Excel 2013, Power BI for Office 365, Excel 2010