Accessing data functions

These functions access data and return table values. Most of these functions return a table value called a navigation table. Navigation tables are primarily used by the Power Query user interface to provide a navigation experience over the potentially large hierarchical data sets returned.

Name	Description
AccessControlEntry.ConditionToIdentities	Returns a list of identities that the condition will accept.
Access.Database	Returns a structural representation of a Microsoft Access database.
ActiveDirectory.Domains	Returns a list of Active Directory domains in the same forest as the specified domain or of the current machine's domain if none is specified.
AdobeAnalytics.Cubes	Returns the report suites in Adobe Analytics.
AdoDotNet.DataSource	Returns the schema collection for an ADO.NET data source.
AdoDotNet.Query	Returns the schema collection for an ADO.NET data source.
AnalysisServices.Database	Returns a table of multidimensional cubes or tabular models from the Analysis Services database.
AnalysisServices.Databases	Returns the Analysis Services databases on a particular host.
AzureStorage.BlobContents	Returns the content of the specified blob from an Azure storage vault.
AzureStorage.Blobs	Returns a navigational table containing all containers found in the Azure Storage account. Each row has the container name and a link to the container blobs.
AzureStorage.DataLake	Returns a navigational table containing the documents found in the specified container and its subfolders from Azure Data Lake Storage.
AzureStorage.DataLakeContents	Returns the content of the specified file from an Azure Data Lake Storage filesystem.
AzureStorage.Tables	Returns a navigational table containing a row for each table found at the account URL from an Azure storage vault. Each row contains a link to the azure table.
Cdm.Contents	This function is unavailable because it requires .NET 4.5.
Csv.Document	Returns the contents of a CSV document as a table using the specified encoding.
Cube.AddAndExpandDimensionColumn	Merges the specified dimension table, dimensionSelector, into the cube's, cube, filter context and changes the dimensional granularity by expanding the specified set, attributeNames, of dimension attributes.
Cube.AddMeasureColumn	Adds a column with the name column to the cube that contains the results of the measure measureSelector applied in the row context of each row.
Cube.ApplyParameter	Returns a cube after applying parameter with arguments to cube.
Cube.AttributeMemberId	Returns the unique member identifier from a member property value.
Cube.AttributeMemberProperty	Returns the property propertyName of dimension attribute attribute.
Cube.CollapseAndRemoveColumns	Changes the dimensional granularity of the filter context for the cube by collapsing the attributes mapped to the specified columns columnNames.
Cube.Dimensions	Returns a table containing the set of available dimensions within the cube.
Cube.DisplayFolders	Returns a nested tree of tables representing the display folder hierarchy of the objects (for example, dimensions and measures).
Cube.MeasureProperties	Returns a table containing the set of available properties for measures that are expanded in the cube.
Cube.MeasureProperty	Returns the property of a measure.
Cube.Measures	Returns a table containing the set of available measures within the cube.
Cube.Parameters	Returns a table containing the set of parameters that can be applied to cube.
Cube.Properties	Returns a table containing the set of available properties for dimensions that are expanded in the cube.
Cube.PropertyKey	Returns the key of property property.
Cube.ReplaceDimensions	Replaces the set of dimensions returned by Cube.Dimensions.
Cube.Transform	Applies the list cube functions, transforms, on the cube.
DB2.Database	Returns a table of SQL tables and views available in a Db2 database.
DeltaLake.Table	Returns the contents of the Delta Lake table.
Essbase.Cubes	Returns the cubes in an Essbase instance grouped by Essbase server.
Excel.CurrentWorkbook	Returns the tables in the current Excel Workbook.
Excel.Workbook	Returns a table representing sheets in the given excel workbook.
Exchange.Contents	Returns a table of contents from a Microsoft Exchange account.
File.Contents	Returns the binary contents of the file located at a path.
Folder.Contents	Returns a table containing the properties and contents of the files and folders found in the specified folder.
Folder.Files	Returns a table containing a row for each file found at a folder path, and subfolders. Each row contains properties of the folder or file and a link to its content.
GoogleAnalytics.Accounts	Returns the Google Analytics accounts for the current credential.
Hdfs.Contents	Returns a table containing a row for each folder and file found at the folder url, {0}, from a Hadoop file system. Each row contains properties of the folder or file and a link to its content.
Hdfs.Files	Returns a table containing a row for each file found at the folder url, {0}, and subfolders from a Hadoop file system. Each row contains properties of the file and a link to its content.
HdInsight.Containers	Returns a navigational table containing all containers found in the HDInsight account. Each row has the container name and table containing its files.
HdInsight.Contents	Returns a navigational table containing all containers found in the HDInsight account. Each row has the container name and table containing its files.
HdInsight.Files	Returns a table containing a row for each folder and file found at the container URL, and subfolders from an HDInsight account. Each row contains properties of the file/folder and a link to its content.
Html.Table	Returns a table containing the results of running the specified CSS selectors against the provided HTML.
Identity.From	Creates an identity.
Identity.IsMemberOf	Determines whether an identity is a member of an identity collection.
IdentityProvider.Default	The default identity provider for the current host.
Informix.Database	Returns a table of SQL tables and views available in an Informix database on server server in the database instance named database.
Json.Document	Returns the contents of a JSON document. The contents may be directly passed to the function as text, or it may be the binary value returned by a function like File.Contents.
Json.FromValue	Produces a JSON representation of a given value value with a text encoding specified by encoding.
MySQL.Database	Returns a table with data relating to the tables in the specified MySQL Database.
OData.Feed	Returns a table of OData feeds offered by an OData serviceUri.
Odbc.DataSource	Returns a table of SQL tables and views from the ODBC data source specified by the connection string connectionString.
Odbc.InferOptions	Returns the result of trying to infer SQL capabilities for an ODBC driver.
Odbc.Query	Connects to a generic provider with the given connection string and returns the result of evaluating the query.
OleDb.DataSource	Returns a table of SQL tables and views from the OLE DB data source specified by the connection string.
OleDb.Query	Returns the result of running a native query on an OLE DB data source.
Oracle.Database	Returns a table with data relating to the tables in the specified Oracle Database.
Pdf.Tables	Returns any tables found in a PDF file.
PostgreSQL.Database	Returns a table with data relating to the tables in the specified PostgreSQL Database.
RData.FromBinary	Returns a record of data frames from the RData file.
Salesforce.Data	Connects to the Salesforce Objects API and returns the set of available objects (i.e. Accounts).
Salesforce.Reports	Connects to the Salesforce Reports API and returns the set of available reports.
SapBusinessWarehouse.Cubes	Returns the InfoCubes and queries in an SAP Business Warehouse system grouped by InfoArea.
SapHana.Database	Returns the packages in an SAP HANA database.
SharePoint.Contents	Returns a table containing a row for each folder and document found at the SharePoint site url. Each row contains properties of the folder or file and a link to its content.
SharePoint.Files	Returns a table containing a row for each document found at the SharePoint site url, and subfolders. Each row contains properties of the folder or file and a link to its content.
SharePoint.Tables	Returns a table containing the result of a SharePoint List as an OData feed.
Soda.Feed	Returns the resulting table of a CSV file that can be accessed using the SODA 2.0 API. The URL must point to a valid SODA-compliant source that ends in a .csv extension.
Sql.Database	Returns a table containing SQL tables located on a SQL Server instance database.
Sql.Databases	Returns a table with references to databases located on a SQL Server instance. Returns a navigation table.
Sybase.Database	Returns a table with data relating to the tables in the specified Sybase Database.
Teradata.Database	Returns a table with data relating to the tables in the specified Teradata Database.
WebAction.Request	Creates an action that, when executed, will return the results of performing a method request against url using HTTP as a binary value.
Web.BrowserContents	Returns the HTML for the specified URL, as viewed by a web browser.
Web.Contents	Returns the contents downloaded from a web URL as a binary value.
Web.Headers	Returns the HTTP headers downloaded from the URL as a record value.
Web.Page	Returns the contents of an HTML webpage as a table.
Xml.Document	Returns the contents of an XML document as a hierarchical table (list of records).
Xml.Tables	Returns the contents of an XML document as a nested collection of flattened tables.