Access Data
Access Data functions for Power Query M language.
Functions
| Function | Description |
|---|---|
| Access.Database | This function retrieves a structural overview of an Access database. It includes an optional parameter called options that can be used to adjust specific settings. The options include CreateNavigation... |
| ActiveDirectory.Domains | Retrieves a list of Active Directory domains that belong to the same forest as the domain specified, or the domain of the current machine if no domain is specified. |
| AdoDotNet.DataSource | This function retrieves the schema collection for the ADO.NET data source using the specified providerName and connectionString. The connectionString can be in text format or a set of key-value pairs.... |
| AdoDotNet.Query | This function retrieves the output of a query by utilizing the ADO.NET provider named providerName, with the connection string specified in the parameter connectionString. The connectionString can eit... |
| AdobeAnalytics.Cubes | This function retrieves a table containing multiple packages from Adobe Analytics. Optionally, you can specify a parameter called options to customize certain settings: - HierarchicalNavigation: A bo... |
| AnalysisServices.Database | This function retrieves a table of multidimensional cubes or tabular models from the Analysis Services database on a specified server. An optional parameter called "options" can be used to customize ... |
| AnalysisServices.Databases | This function retrieves databases from an Analysis Services server instance. An optional parameter called "options" can be provided to specify additional properties. The "options" parameter can includ... |
| AzureStorage. DataLake | The function returns a table containing the documents found in the specified container and its subfolders at the account URL endpoint from an Azure Data Lake Storage filesystem. Users can specify opti... |
| AzureStorage.BlobContents | No description available |
| AzureStorage.Blobs | No description available |
| AzureStorage.DataLakeContents | This function retrieves the file content located at the specified URL from an Azure Data Lake Storage filesystem. Various options can be set to customize the behavior: - BlockSize: Determines the siz... |
| AzureStorage.Tables | The function retrieves a navigation table from an Azure storage vault, displaying a row for every table found at the specified account URL. Each row includes a link to the corresponding Azure table. U... |
| Binary Functions | No description available |
| BinaryFormat.7BitEncodedSignedInteger | A data format that interprets a 64-bit signed integer which has been compressed using a variable-length encoding method with 7 bits. |
| Cdm.AddMeasureColumn | A new column named "column" is created in the cube, displaying the results of the measure measureSelector applied within the row context of each row. The application of the measure is influenced by mo... |
| Cdm.Contents | No description available |
| Csv.Document | This function returns the contents of a CSV document in the form of a table. The columns in the table can have various attributes such as being nullable, having a specific number of columns, a list of... |
| Cube.AddAndExpandDimensionColumn | Incorporates the chosen dimension table, dimensionSelector, into the cube's, cube, filter context and adjusts the dimensional level by including the selected group, attributeNames, of dimension attrib... |
| Cube.AddMeasureColumn | A new column named "column" is created in the cube, displaying the results of the measure measureSelector applied within the row context of each row. The application of the measure is influenced by mo... |
| Cube.ApplyParameters | This function will output a cube after the specified parameter and arguments have been applied to it. |
| Cube.AttiributeMemberProperty | This function retrieves the specific property named propertyName from the attribute dimension. |
| Cube.AttiributeMemberld | This function retrieves the distinct member identifier associated with a specific member property value. It will return a null value for any values that are not associated with a member. |
| Cube.CollapseAndRemoveColumns | This function adjusts the level of detail in the filter context of the cube by combining the attributes associated with the specified columns. These columns will no longer be displayed in the tabular ... |
| Cube.Dimensions | This function retrieves a table that shows the dimensions available in the cube. Each dimension is displayed as a table that includes a set of attributes, with each attribute appearing as a column in ... |
| Cube.DisplayFolders | The function generates a hierarchy of tables that show the organization of display folders for objects (such as dimensions and measures) that can be utilized in the cube. |
| Cube.MeasureProperties | Returns a table that shows all the different properties for measures that have been expanded within the cube. |
| Cube.MeasureProperty | This function retrieves the characteristic of a measurement. |
| Cube.Measures | This function retrieves a list of measures that are currently selectable within the cube. Each measure is stored as a function that can be added to the cube using Cube.AddMeasureColumn. |
| Cube.Parameters | This function retrieves a table which lists the parameters that can be utilized for the cube. Each parameter is a function that, when called, will apply the specified arguments to the cube. |
| Cube.Properties | A table is generated that displays the range of properties that are accessible for expanded dimensions within the cube. |
| Cube.PropertyKey | This function retrieves the key associated with the specified property. |
| Cube.ReplaceDimensions | Substitutes the collection of dimensions retrieved from Cube.Dimensions. This function is typically used to include an identification column to a dimension attribute, enabling the data source to categ... |
| Cube.Tranform | Utilizes the cube's list of functions, called transforms, to perform operations on the cube. |
| DB2.Database | This function retrieves a list of all SQL tables and views from a Db2 database located on a specific server and database instance. The port can also be specified, if necessary, by appending it with a ... |
| DeltaLake.Table | This function retrieves the data stored in the Delta Lake table. |
| Essbase.Cubes | This function retrieves a table showing cubes arranged by Essbase server from a specific Essbase instance located at the APS server URL. Users can specify additional options by including a record para... |
| Excel.CurrentWorkbook | This function retrieves the data found within the current Excel workbook. It will retrieve tables, named ranges, and dynamic arrays. It should be noted that unlike the Excel.Workbook function, this pa... |
| Excel.Workbook | This function retrieves the data from an Excel workbook. The parameter useHeaders can be set to either true or false, indicating whether the first row of each returned table should be considered as a ... |
| Exchange.Contents | This function retrieves a table of contents from the mailboxAddress of a Microsoft Exchange account. If no mailboxAddress is provided, the default account associated with the credential will be utiliz... |
| File.Contents | This function retrieves the binary content of the specified file path. Note that the options parameter is meant for internal use only at this time. |
| Folder.Contents | The function retrieves a table with detailed information about each folder and file within the specified folder path. Each entry in the table includes attributes of the folder or file and a hyperlink ... |
| Folder.Files | The function retrieves a table that includes a row for every file discovered in the specified folder path and its subdirectories. Each row provides details about the file, along with a hyperlink to it... |
| GoogleAnalytics.Accounts | Retrieves Google Analytics accounts that can be accessed using the current credentials. |
| HdInsight.Containers | Generates a navigational table with a row for every container discovered at the specified URL in the Azure storage vault account. Each row includes a hyperlink to access the blobs within the container... |
| HdInsight.Contents | Generates a navigational table with a row for every container discovered at the specified URL in the Azure storage vault account. Each row includes a hyperlink to access the blobs within the container... |
| HdInsight.Files | This function retrieves a table that includes a row for every blob file located at the specified container URL within an Azure storage account. Each row within the table displays the file's properties... |
| Hdfs.Contents | The function retrieves a table with a row for every folder and file discovered at the specified folder URL in a Hadoop file system. Each row includes details about the folder or file as well as a hype... |
| Hdfs.Files | The function retrieves a table that includes a row for every file located at the specified folder URL in a Hadoop file system, including any subfolders. Each row provides details about the file proper... |
| Html.Table | This function generates a table that displays the outcome of applying the designated CSS selectors to the given HTML content. Users have the option to provide an additional record called options, whic... |
| Identity.From | Generates a unique identity. |
| Identity.IsMemberOf | This function checks if a particular identity belongs to a specific set of identities. |
| IdentityProvider.Default | The identity provider that is automatically set for the existing host. |
| Informix.Database | The function retrieves a list of SQL tables and views found in an Informix database located on the server named server within the database instance named database. The port can be specified alongside ... |
| Json.Document | This function retrieves the data from a JSON document. The data can be provided to the function as text directly or it can be the binary output produced by a function such as File.Contents. |
| Json.FromValue | This function generates a JSON format of a given value, using a specified text encoding provided by encoding. If encoding is not specified, UTF8 is used as the default. The values are represented in t... |
| MySQL.Database | The function retrieves a list of tables, views, and stored scalar functions available in a MySQL database on a specified server and database instance. The port can be specified with the server address... |
| OData.Feed | This function retrieves a table of OData feeds provided by an OData service from a specified serviceUri and headers. Users can also specify options using a boolean value to enable concurrent connectio... |
| 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... |
| Odbc.InferOptions | This function determines the SQL capabilities with the specified connection string using ODBC. The connection string can consist of either text or a collection of key-value pairs. The values of the pr... |
| Odbc.Query | This function retrieves the outcome of executing a query using the ODBC connection specified by the connectionString parameter. The connectionString can be either a text string or a set of property-va... |
| OleDb.DataSource | This function retrieves a table of SQL tables and views from the OLE DB data source specified by the connection string provided in the connectionString parameter. The connectionString can be in text f... |
| OleDb.Query | This function retrieves the output of a query executed using OLE DB with the provided connection string. The connectionString can be in the form of plain text or as a set of key-value pairs. The prope... |
| Oracle.Database | This function retrieves a list of SQL tables and views from the Oracle database located on a specified server. The port number can be provided along with the server address, separated by a colon. You... |
| Pdf.Tables | This function retrieves any tables present in a PDF file. An optional parameter, named options, can be provided to define additional properties. The options parameter can include the following fields:... |
| PostgreSQL.Database | This function retrieves a list of SQL tables and views available in a PostgreSQL database on a specified server within a database instance. The port for the server can be optionally specified by addin... |
| RData.FromBinary | This function retrieves a dataset stored in a file in RData format and returns it as a collection of data frames. |
| Salesforce.Data | This function retrieves the objects associated with the specified Salesforce account using the provided credentials. The account will be accessed through the loginUrl specified in the environment para... |
| Salesforce.Reports | The function retrieves the reports from the Salesforce account specified in the login credentials. The account will be linked through the loginUrl provided for the environment. If no specific environm... |
| SapBusinessWarehouse.Cubes | Retrieves a list of InfoCubes and queries organized by InfoArea from an SAP Business Warehouse system located on the server specified by server with system number systemNumberOrSystemId and Client ID ... |
| SapHana.Database | This function retrieves a table of multidimensional packages from the SAP HANA database server. You can define optional parameters, known as options, to specify various settings: - Query: A native SQL... |
| SharePoint.Contents | This function retrieves a table listing all folders and documents located at the provided SharePoint site URL. Each row in the table displays properties of the folder or file along with a link to acce... |
| SharePoint.Files | This function retrieves a table with information on each document found in the designated SharePoint site, URL, and subfolders. Each row in the table includes details about the folder or file as well ... |
| SharePoint.Tables | This function retrieves a table with a row for each item in the specified SharePoint list URL. Each row contains properties of the list. Options can be set to control the following parameters: - ApiVe... |
| Soda.Feed | Retrieves a table from the data found at the provided URL address in a format that follows the guidelines of the SODA 2.0 API. The URL should direct to a legitimate source that adheres to SODA standar... |
| Sql.Database | Retrieve a list of tables, views, and stored functions from a SQL Server database located on a specified server. The port number can be indicated alongside the server address using a colon or comma. A... |
| Sql.Databases | This function retrieves a list of databases from a specified SQL server. It accepts an optional parameter called options, which can be used to customize various settings: - CreateNavigationProperties... |
| Sybase.Database | This function retrieves a list of SQL tables and views that are accessible in a Sybase database stored on a specified server within the database instance called "database." The server's port can be in... |
| Teradata.Database | This function retrieves a list of SQL tables and views from a Teradata database located on a specified server. The port number can be indicated by appending a colon after the server address. Users can... |
| Web.BrowserContents | This function retrieves the HTML content of a specified URL as it would appear in a web browser. An optional parameter, options, can be provided to specify additional properties. The options parameter... |
| Web.Contents | This function retrieves the data downloaded from a specified URL in binary format. Optional parameters, referred to as options, can be provided to define additional properties. The options record can ... |
| Web.Headers | The function retrieves the headers that have been downloaded from a specified URL and returns them as a record. If desired, an additional record parameter called "options" can be included to specify e... |
| Web.Page | The function retrieves the elements of the HTML document separated into their individual structures, along with a depiction of the complete document and its text without the HTML tags. |
| WebAction.Request | This function creates an action that can be executed to retrieve the results of a method request from a specified URL using HTTP as a binary value. Optional parameters, referred to as options, can be ... |
| Xml.Document | Returns the data from the XML document in a structured table format, showing the hierarchy of information. |
| Xml.Tables | This function retrieves the data from the XML document and organizes it into a structured format of nested tables. |