Accessing Data Functions

Functions for connecting to and reading from data sources.

Access.Database
Returns a structural representation of a Microsoft Access database.
AccessControlEntry.ConditionToIdentities
Converts an access control condition into a list of identities for which the condition would return true.
ActiveDirectory.Domains
Returns a table of Active Directory domains accessible from the current machine or from a specified domain controller.
AdobeAnalytics.Cubes
Returns a table of multidimensional packages from Adobe Analytics.
AdoDotNet.DataSource
Returns the schema collection for an ADO.NET data source with the specified provider name and connection string.
AdoDotNet.Query
Returns the result of running a SQL query against an ADO.NET data source with the specified provider name and connection string.
AnalysisServices.Database
Returns a navigation table of cubes and tables from an Analysis Services or Azure Analysis Services database.
AnalysisServices.Databases
Returns the databases on a SQL Server Analysis Services instance.
AzureStorage.BlobContents
Returns the content of a blob from Azure Blob Storage as binary.
AzureStorage.Blobs
Returns a navigation table of containers and blobs from an Azure Blob Storage account.
AzureStorage.DataLake
Returns a navigational table of documents from an Azure Data Lake Storage filesystem.
AzureStorage.DataLakeContents
Returns the content of a file from Azure Data Lake Storage as binary.
AzureStorage.Tables
Returns a navigation table of Azure Table Storage tables from the specified storage account.
Cdm.Contents
Returns a table representing the entities defined in a Common Data Model folder.
Csv.Document
Parses CSV text into a table.
DB2.Database
Returns a navigation table of SQL tables and views from an IBM Db2 database.
DeltaLake.Metadata
Returns the transaction log entries for a Delta Lake table.
DeltaLake.Table
Returns the contents of a Delta Lake table from a specified directory.
Essbase.Cubes
Returns a table of cubes grouped by Essbase server from an Oracle Essbase instance.
Excel.CurrentWorkbook
Returns a navigation table of tables and named ranges from the current Excel workbook.
Excel.ShapeTable
Retrieves shape data from an Excel workbook as a table. This function is intended for internal use only.
Excel.Workbook
Returns the contents of an Excel workbook as a navigation table.
Exchange.Contents
Returns a table of contents from a Microsoft Exchange account mailbox.
FabricAI.Prompt
Returns the result of passing input text to an AI model hosted in Microsoft Fabric.
File.Contents
Returns the contents of a file as binary.
Folder.Contents
Returns a table of files and subfolders in the specified local or network folder path.
Folder.Files
Returns a table of all files in a folder and its subfolders, including their binary content.
GoogleAnalytics.Accounts
Returns a table of Google Analytics accounts accessible from the current credential.
Hdfs.Contents
Returns a table of folders and files found at a folder URL from a Hadoop file system (HDFS).
Hdfs.Files
Returns a table of all files found recursively at a folder URL and its subfolders from a Hadoop file system (HDFS).
HdInsight.Containers
Returns a navigation table of containers from an Azure HDInsight storage account.
HdInsight.Contents
Returns a navigation table of containers from an Azure HDInsight storage vault.
HdInsight.Files
Returns a table of blob files from a specific container in an Azure HDInsight storage account.
Html.Table
Extracts data from HTML content into a table using CSS selectors to define columns.
Identity.From
Creates an identity record from an identity provider and a value.
Identity.IsMemberOf
Determines whether an identity is a member of an identity collection.
IdentityProvider.Default
Returns the default identity provider for the current Power Query host environment.
Informix.Database
Returns a table of SQL tables and views available in an IBM Informix database.
Json.Document
Parses JSON text into M values (records, lists, text, numbers, logicals, or null).
Json.FromValue
Serializes an M value to JSON and returns it as binary.
MySql.Database
Returns a navigation table of tables and views from a MySQL database.
OData.Feed
Returns a navigation table from an OData service at the specified URI.
Odbc.DataSource
Returns a navigation table of tables from an ODBC data source using the given connection string.
Odbc.InferOptions
Returns the result of trying to infer SQL capabilities for an ODBC data source using the given connection string.
Odbc.Query
Returns a table from an ODBC data source by executing the specified SQL 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 SQL query against an OLE DB data source using the specified connection string.
Oracle.Database
Returns a navigation table of tables and views from an Oracle database.
Pdf.Tables
Extracts tables from a PDF file and returns them as a navigation table.
PostgreSQL.Database
Returns a navigation table of tables and views from a PostgreSQL database.
RData.FromBinary
Returns a record of data frames from an R Data (.rdata / .rda) binary file.
Salesforce.Data
Returns a navigation table of objects from a Salesforce account.
Salesforce.Reports
Returns a navigation table of reports from a Salesforce account.
SapBusinessWarehouse.Cubes
Returns a table of InfoCubes and queries grouped by InfoArea from an SAP Business Warehouse instance.
SapHana.Database
Returns a table of multidimensional packages from an SAP HANA database.
SharePoint.Contents
Returns a navigation table of sites, lists, and document libraries from a SharePoint site.
SharePoint.Files
Returns a table of all files from a SharePoint site or document library, including their binary content.
SharePoint.Tables
Returns a navigation table of SharePoint list data from the specified SharePoint site.
Soda.Feed
Returns a table from the contents at the specified URL formatted according to the Socrata Open Data API (SODA) 2.0.
Sql.Database
Returns a navigation table of tables and views from a SQL Server database.
Sql.Databases
Returns a table of databases available on a SQL Server instance.
Sybase.Database
Returns a table of SQL tables and views available in a Sybase database.
Teradata.Database
Returns a table of SQL tables and views from a Teradata database.
Web.BrowserContents
Returns the HTML of a URL as rendered by a web browser, including JavaScript-generated content.
Web.Contents
Downloads content from a URL as binary.
Web.Headers
Returns the HTTP response headers for the specified URL as a record.
Web.Page
Returns the contents of an HTML document parsed into a table of tables, extracting all HTML tables found on the page.
WebAction.Request
Creates an action that, when executed, returns the results of performing an HTTP request against a URL as a binary value.
Xml.Document
Parses XML content into a nested table structure.
Xml.Tables
Returns the contents of an XML document as a nested collection of flattened tables.