Access.Database

 

This topic applies to the Power Query Formula Language which can be used with Power Query and Power BI Desktop to build queries that mashup data. See the list of function categories.

Access.Database(database as binary, optional options as nullable record) as table  

Returns a structural representation of an Access database, database. An optional record parameter, options, may be specified to control the following options:

     
  •  CreateNavigationProperties : A logical (true/false) that sets whether to generate navigation properties on the returned values (default is false).
  •  
  •  NavigationPropertyNameGenerator : A function that is used for the creation of names for navigation properties.
  •  
The record parameter is specified as [option1 = value1, option2 = value2...] for example.

Access.Database(File.Contents("c:\users\myuser\Desktop\mydb.accdb"))  

Show: