Accessing Data Functions Overview

Dive into Accessing Data Functions in Power Query M Language, pivotal for retrieving data. This page provides a comprehensive list and descriptions of Accessing Data Functions available in the M Language.

Table of contents

• Commonly Used Functions
• Power Platform Functions
• Operations
• External Integrations

Dive into Accessing Data Functions in Power Query M Language, pivotal for retrieving data. This page provides a comprehensive list and descriptions of Accessing Data Functions available in the M Language.

Commonly Used Functions

Function	Description	Input	Output
Access.Database	Returns a structural representation of an Access database.	Binary	Table
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.	Text	Table
AnalysisServices.Database	Returns a table of multidimensional cubes or tabular models from the Analysis Services database.	Text	Table
AnalysisServices.Databases	Returns the Analysis Services databases on a particular host.	Text	Table
CommonDataService.Database		Text	Table
Csv.Document	Returns the contents of the CSV document as a table.	Any	Table
Excel.CurrentWorkbook	Returns the contents of the current Excel workbook.	Table	Table
Excel.Workbook	Returns the contents of the Excel workbook.	Binary	Table
Exchange.Contents	Returns a table of contents from a Microsoft Exchange account.	Text	Table
File.Contents	Returns the contents of the specified file as binary.	Text	Binary
Folder.Contents	Returns a table containing the properties and contents of the files and folders found in the specified folder.	Text	Table
Folder.Files	Returns a table containing the properties and contents of the files found in the specified folder and subfolders.	Text	Table
Html.Table	Returns a table containing the results of running the specified CSS selectors against the provided HTML.	Any	Table
Json.Document	Returns the content of the JSON document.	Any	Any
Json.FromValue	Produces a JSON representation of a given value.	Any	Binary
MySQL.Database	Returns a table of SQL tables, views, and stored scalar functions available in a MySQL database.	Text	Table
OData.Feed	Returns a table of OData feeds offered by an OData service.	Text	Any
Odbc.DataSource	Returns a table of SQL tables and views from the ODBC data source	Any	Table
Odbc.InferOptions	Returns the result of trying to infer SQL capabilities for an ODBC driver.	Any	Record
Odbc.Query	Returns the result of running a native query on an ODBC data source.	Any	Table
OleDb.DataSource	Returns a table of SQL tables and views from the OLE DB data source.	Any	Table
OleDb.Query	Returns the result of running a native query on an OLE DB data source.	Any	Table
Oracle.Database	Returns a table of SQL tables and views from the Oracle database.	Text	Table
Parquet.Document	Returns the contents of the Parquet document as a table.	Binary	Any
Parquet.Metadata	This function is intended for internal use only.	Binary	Any
Pdf.Tables	Returns any tables found in a PDF file.	Binary	Table
PostgreSQL.Database	Returns a table of SQL tables and views available in a PostgreSQL database.	Text	Table
PowerBI.Dataflows		Record	Table
PowerBI.Datamarts	Imports data from Datamarts	Text	Table
PowerBIDatasets.Actions	Connect to PowerBIDatasets	Table	Table
PowerPlatform.Dataflows	Import data from a dataflow	Record	Table
Python.Execute	Executes Python script and returns data frames	Text	Table
R.Execute		Text	Table
Resource.Access		Any	Any
SapHana.Database	Returns the packages in an SAP HANA database.	Text	Table
SharePoint.Contents	Returns a table containing content from a SharePoint site.	Text	Table
SharePoint.Files	Returns a table containing documents from a SharePoint site.	Text	Table
SharePoint.Tables	Returns a table containing content from a SharePoint List.	Text	Table
Sql.Database	Returns a table of SQL tables, views, and stored functions from the SQL Server database.	Text	Table
Sql.Databases	Returns a table of databases on a SQL Server.	Text	Table
Synapse.Contents		Record	Table
Web.Contents	Returns the contents downloaded from the url as binary.	Text	Binary
Web.Headers	Returns the HTTP headers downloaded from the url as a record value.	Text	Record
Web.Page	Returns the contents of the HTML document broken into its constituent structures, as well as a representation of the full document and its text after removing tags.	Any	Table
WebAction.Request	Creates an action that, when executed, will return the results of performing an HTTP request as a binary value.	Text	Any
Xml.Document	Returns the contents of the XML document as a hierarchical table.	Any	Table
Xml.Tables	Returns the contents of the XML document as a nested collection of flattened tables.	Any	Table

External Integrations

Function	Description	Input	Output
AIInsights.Contents		Any	Any
AIInsights.ContentsGenerator		Any	Any
AML.ExecuteBatch		Text	Any
Acterys.Contents		Any	Any
Actian.Contents		Text	Any
AdoDotNet.DataSource	Returns the schema collection for an ADO.NET data source.	Text	Table
AdoDotNet.Query	Returns the result of running a native query on an ADO.NET data source.	Text	Table
AdobeAnalytics.Cubes	Returns the report suites in Adobe Analytics.	Record	Table
AmazonAthena.Databases		Text	Table
AmazonOpenSearchService.Contents		Text	Table
AmazonRedshift.Database	Import data from an Amazon Redshift database.	Text	Table
AmazonS3.Storage	Used to connect to Amazon S3.	Text	Table
Anaplan.Contents		Text	Table
ApacheHiveLLAP.Database	Import data from a Hive LLAP	Text	Table
ApacheSpark.Tables	Returns a table listing the tables on the specified Spark cluster.	Text	Table
Asana.Tables		Text	Table
AssembleViews.Contents		Text	Table
AssembleViews.Feed		Text	Table
AtScale.Cubes	Import/DirectQuery cube data from an AtScale.	Text	Table
AutodeskConstructionCloud.Contents		Text	Table
AutodeskConstructionCloud.Feed		Text	Table
AutomationAnywhere.Feed		Text	Table
AutomyDataAnalytics.Contents		Table	Table
BI360.Contents		Text	Table
BIConnector.Contents	Enter connection information	Text	Table
BQECore.Contents		Any	Any
BQL.Query	Used for retrieving Bloomberg data	Text	Table
BitSightSecurityRatings.Contents		Text	Any
CDataConnectCloud.Contents		Record	Table
Cdm.Contents	This function is unavailable because it requires .NET 4.5.	Table	Table
Cdm.MapToEntity	Returns a table with columns mapped to the attributes of an entity in the Common Data Model, including data types.	Table	Table
Cdpa.Database	Provides access to a CDPA database.	Text	Any
Cds.Contents		Text	Any
Cds.Entities		Text	Table
Celonis.KnowledgeModels		Text	Table
Celonis.Navigation		Text	Table
Cherwell.SavedSearches		Text	Table
CloudBluePSA.Feed		Text	Table
Cognite.Contents		Text	Table
CosmosDB.Contents		Text	Table
CustomerInsights.Contents		Record	Table
DB2.Database	Returns a table of SQL tables and views available in a Db2 database.	Text	Table
DCWInsights.Feed		Text	Table
DataLakeAnalytics.Account	Connect to Azure Data Lake Analytics account	Text	Table
DataPipelineCosmosDb.Contents	Used to connect to Azure CosmosDB with a data pipeline	Text	Table
DataVirtuality.Database		Text	Table
DataWorld.Contents		Table	Table
DataWorld.Dataset		Text	Table
DeltaSharing.Contents		Text	Table
Denodo.Contents		Text	Table
DocumentDB.Contents	Enter the URL of an Azure Cosmos DB account.	Text	Table
Dremio.Databases		Text	Table
Dremio.DatabasesV300		Text	Table
DremioCloud.Databases		Text	Table
DremioCloud.DatabasesByServer		Text	Table
DremioCloud.DatabasesByServerV330		Text	Table
DremioCloud.DatabasesByServerV360	Returns a table listing the datasets on the specified server on Dremio Cloud	Text	Table
Dynamics365BusinessCentral.ApiContents	Enter your Dynamics 365 Business Central environment and company.	Text	Table
Dynamics365BusinessCentral.ApiContentsWithOptions	Enter your Dynamics 365 Business Central environment and company.	Text	Table
Dynamics365BusinessCentral.Contents	Enter your Dynamics 365 Business Central environment and company.	Text	Table
Dynamics365BusinessCentral.EnvironmentContents	Enter your Dynamics 365 Business Central environment and company.	Text	Table
Dynamics365BusinessCentralOnPremises.Contents	Enter the URL of your Dynamics 365 Business Central (on-premises) OData service endpoint.	Text	Table
DynamicsNav.Contents	Enter the URL of your Dynamics NAV OData service endpoint.	Text	Table
EQuIS.Contents		Text	Table
EduFrame.Contents		Text	Table
ElasticSearch.Database		Text	Table
Emigo.Contents		Text	Table
Emigo.GetExtractFunction		Text	Any
EmigoDataSourceConnector.GetExtractFunction		Text	Any
EmplifiMetrics.Contents		Record	Table
EntersoftBusinessSuite.Contents		Any	Any
Essbase.Cubes	Returns the cubes in an Essbase instance grouped by Essbase server.	Text	Table
EventHub.Contents	Used to connect to Azure Event Hub.	Text	Table
Exasol.Database		Text	Table
FactSetAnalytics.AuthenticationCheck		Any	Any
FactSetAnalytics.Functions		Table	Table
FactSetRMS.Functions		Record	Table
Fhir.Contents		Text	Table
Foundry.Contents		Text	Table
Funnel.Contents		Table	Table
Github.Contents		Text	Any
Github.PagedTable		Text	Any
Github.Tables	Enter the GitHub repository owner and the repository name.	Text	Table
GoogleAnalytics.Accounts	Returns Google Analytics accounts.	Table	Table
GoogleBigQuery.Database	Import data from a Google BigQuery database.	Record	Table
GoogleBigQueryAad.Database	Import data from a Google BigQuery database using Azure AD	Text	Table
GoogleCloudStorage.Storage	Used to connect to Google Cloud Storage.	Text	Table
GoogleSheets.Contents	Imports data from GoogleSheets	Text	Table
GraphDataset.ExtractMetadataAndContents		Binary	Record
GraphDataset.FileSystemChanges		Text	Any
HdInsight.Containers	Returns a navigational table containing the containers found in the specified account from an Azure storage vault.	Text	Table
HdInsight.Contents	Returns a navigational table containing the containers found in the specified account from an Azure storage vault.	Text	Table
HdInsight.Files	Returns a table containing the properties and contents of the blobs found in the specified container from an Azure storage vault.	Text	Table
Hdfs.Contents	Returns a table containing the properties and contents of the files and folders found in the specified folder from a Hadoop file system.	Text	Table
Hdfs.Files	Returns a table containing the properties and contents of the files found in the specified folder and subfolders from a Hadoop file system.	Text	Table
HexagonSmartApi.ApplySelectList		Text	Table
HexagonSmartApi.ApplyUnitsOfMeasure		Text	Any
HexagonSmartApi.ExecuteParametricFilterOnFilterRecord		Text	Any
HexagonSmartApi.ExecuteParametricFilterOnFilterUrl		Text	Any
HexagonSmartApi.Feed		Text	Table
HexagonSmartApi.GenerateParametricFilterByFilterSourceType		Text	Any
HexagonSmartApi.GetODataMetadata		Text	Any
HexagonSmartApi.Typecast		Any	Function
IRIS.Database		Text	Table
Impala.Database	Import data from an Impala cluster	Text	Table
Indexima.Database		Text	Table
IndustrialAppStore.NavigationTable		Table	Table
InformationGrid.Contents		Text	Table
Informix.Database	Returns a table of SQL tables and views available in an Informix database.	Text	Table
Intune.Contents		Number	Table
IoTHub.Contents	Used to connect to Azure IoT Hub.	Text	Table
JamfPro.Contents		Text	Any
JethroODBC.Database		Text	Table
Kognitwin.Contents		Text	Table
Kusto.Contents	Imports data from Azure Data Explorer (Kusto)	Text	Table
Kusto.Databases		Text	List
Kyligence.Database		Text	Table
Linkar.Contents		Text	Table
LinkedIn.SalesContracts		Table	Table
LinkedIn.SalesContractsWithReportAccess		Table	Table
LinkedIn.SalesNavigator		Text	Table
LinkedIn.SalesNavigatorAnalytics		Text	Table
LinkedIn.SalesNavigatorAnalyticsImpl		Text	Any
MQ.Queue	Returns a table of messages available in the queue via a non-destructive read.	Text	Table
MailChimp.Collection	Returns a table with data from a MailChimp endpoint.	Text	Table
MailChimp.Instance	Returns raw response results from a MailChimp API endpoint.	Text	Table
MailChimp.Tables		Table	Table
MailChimp.TablesV2	Returns a table with key MailChimp data.	Table	Table
MariaDB.Contents		Text	Table
MarkLogicODBC.Contents		Text	Table
Marketo.Activities	Returns a table with lead activities.	Text	Table
Marketo.Leads	Returns a table with lead details.	Text	Table
Marketo.Tables	Enter the URL of the Marketo REST API endpoint associated with your account.	Text	Table
MicroStrategyDataset.Contents		Text	Table
MicroStrategyDataset.TestConnection		Text	Any
Mixpanel.Contents		Text	Any
Mixpanel.Export		Text	Any
Mixpanel.FunnelById		Number	Any
Mixpanel.FunnelByName		Text	Any
Mixpanel.Funnels		Any	Any
Mixpanel.Segmentation		Text	Any
Mixpanel.Tables		Any	Any
MongoDBAtlasForPipeline.Database	Connect to MongoDB Atlas For Pipeline	Text	Any
MongoDBAtlasODBC.Contents		Text	Table
MongoDBAtlasODBC.Query		Text	Table
MongoDBForPipeline.Contents	Used to connect to MongoDB For Pipeline.	Text	Any
Netezza.Database	Import data from an IBM Netezza database.	Text	Table
OpenSearchProject.Contents		Text	Table
OracleERP.Contents		Text	Any
Paxata.Contents		Text	Table
PlanviewEnterprise.CallQueryService	Enter the URL, database name associated with your Planview Portfolios account and a SQL query.	Text	Table
PlanviewEnterprise.Feed	Enter the URL and database name associated with your Planview Portfolios account.	Text	Table
PlanviewOKR.Contents	Enter the URL of your Planview OKR account.	Text	Table
PlanviewProjectplace.Contents	Enter the URL of your Planview Projectplace account.	Text	Table
ProductInsights.Contents		Table	Table
ProductInsights.QueryMetric		Text	Any
Profisee.Tables		Text	Table
Projectplace.Feed	Enter the URL of your Planview Projectplace account.	Text	Table
QubolePresto.Contents		Text	Any
QuickBase.Contents		Text	Table
QuickBooks.Query		Text	Table
QuickBooks.Report		Text	Table
QuickBooks.Tables		Any	Any
QuickBooksOnline.Tables	Import data from QuickBooks Online.	Record	Table
RData.FromBinary	Returns a record of data frames from the RData file.	Binary	Any
Roamler.Contents		Any	Any
SAPERP.Functions	Import data from SAP RFCs	Text	Table
SDMX.Contents		Text	Table
Salesforce.Data	Returns the objects from the Salesforce account.	Any	Table
Salesforce.Reports	Returns the reports from the Salesforce account.	Text	Table
SapBusinessWarehouse.Cubes	Returns the InfoCubes and queries in an SAP Business Warehouse system grouped by InfoArea.	Text	Table
ShortcutsBI.Contents		Table	Table
SingleStoreODBC.DataSource		Text	Table
SingleStoreODBC.Database		Text	Table
SingleStoreODBC.Query		Text	Table
Siteimprove.Contents		Table	Table
Smartsheet.Content	Returns a table of data from an Smartsheet index endpoint.	Text	Any
Smartsheet.Query	Returns a JSON result from the Smartsheet API	Text	Any
Smartsheet.Tables	Returns a table of sheets, reports, folders, and workspaces from the Smartsheet API	Table	Table
Snowflake.Databases	Import data from a Snowflake Computing warehouse.	Text	Table
SocialbakersMetrics.Contents		Record	Table
Soda.Feed	Returns a table from the contents at the specified URL formatted according to the SODA 2.0 API.	Text	Table
SoftOneBI.Contents		Table	Table
SolarWindsServiceDesk.Contents		Any	Any
SolarWindsServiceDesk.TestContents		Any	Any
Spark.Tables	Returns a table listing the tables on the specified Spark cluster.	Text	Table
SparkPost.GetList		Text	Table
SparkPost.GetTable	Returns a table of available metrics from the SparkPost API v1	Number	Table
SparkPost.NavTable		Number	Table
Spigit.Contents	Enter the URL of your Planview IdeaPlace account.	Text	Table
StarburstPresto.Contents		Text	Table
Stripe.Contents	Makes a call to the Stripe API, with the option to limit number of API calls made.	Text	Table
Stripe.Method	Makes a call to the Stripe API.	Text	Table
Stripe.Tables	Returns a table listing the available Stripe tables and functions.	Table	Table
SumTotal.ODataFeed		Text	Table
SurveyMonkey.Contents		Table	Table
SweetIQ.Contents		Text	Any
SweetIQ.Tables		Any	Any
Sybase.Database	Returns a table of SQL tables and views available in a Sybase database.	Text	Table
TeamDesk.Database		Text	Table
TeamDesk.Select		Text	Table
TeamDesk.SelectView		Text	Table
TeamsAnalytics.Contents		Table	Table
Tenforce.Contents		Text	Table
Teradata.Database	Returns a table of SQL tables and views from the Teradata database.	Text	Table
TibcoTdv.DataSource		Text	Table
TimeSeriesInsights.Contents		Record	Table
TridentPipelines.ApplyUser		Any	Any
TridentPipelines.CancelExecution		Any	Any
TridentPipelines.Create		Any	Any
TridentPipelines.CreateDataFactory		Any	Any
TridentPipelines.Delete		Any	Any
TridentPipelines.Execute		Any	Any
TridentPipelines.GetDataFactory		Any	Any
TridentPipelines.GetExecutionStatus		Any	Any
TridentPipelines.Service		Any	Any
TridentPipelines.User		Any	Any
Troux.CustomFeed	Enter the URL of your Planview Enterprise Architecture account and a query.	Text	Table
Troux.Feed	Enter the URL of your Planview Enterprise Architecture account.	Text	Table
Troux.TestConnection		Text	Any
Twilio.Contents		Any	Any
Twilio.Tables	Enter the number of months of historical Twilio data to retrieve.	Number	Table
Twilio.URL		Any	Any
Usercube.Universes		Text	Table
VSTS.AccountContents	Enter Url of your Azure DevOps Analytics Service.	Text	Table
VSTS.AnalyticsViews	Enter organization and project names.	Text	Table
VSTS.Contents	Enter Url of your Azure DevOps Analytics Service.	Text	Table
VSTS.Feed	Azure DevOps Services Feed	Text	Table
VSTS.Views	Enter organization and project names.	Text	Table
Vena.Contents		Text	Table
Vertica.Database	Import data from Vertica	Text	Table
VesselInsight.Contents		Any	Any
VivaInsights.Data		Text	Table
Web.BrowserContents	Returns the HTML for the specified URL, as viewed by a web browser.	Text	Text
WebForPipeline.Contents	Connect to Web V2	Text	Table
Webtrends.KeyMetrics	Returns a table with key Webtrends metrics.	Text	Table
Webtrends.Profile		Any	Any
Webtrends.ReportContents	Returns a table with report content from Webtrends.	Text	Table
Webtrends.Tables	Enter the Profile ID associated with your Webtrends account.	Text	Table
WebtrendsAnalytics.Tables	Enter the Profile ID associated with your Webtrends account.	Text	Table
Witivio.Contents		Text	Table
WorkforceDimensions.Contents		Text	Text
WorkplaceAnalytics.Data		Text	Table
Wrike.Contents		Table	Table
Zendesk.Collection		Any	Any
Zendesk.Tables	Enter the URL of your Zendesk account.	Text	Table
ZohoCreator.Contents		Text	Any
Zucchetti.Contents		Text	Table
appFigures.Content		Text	Any
appFigures.Tables		Table	Table
eWayCRM.Contents		Logical	Table

Operations

Function	Description	Input	Output
AI.ExecuteInProc		Text	Any
AI.ExecuteInternal		Text	Any
AI.ExternalSort		Table	Any
AI.GetAutoMLEntity		Text	Any
AI.SampleStratifiedWithHoldout		Text	Any
AI.TestConnection		Any	Any
AIFunctions.Capacities		Any	Any
AIFunctions.Contents		Any	Any
AIFunctions.ExecuteInternal		Text	Any
AIFunctions.GetAutoMLEntity		Text	Any
AIFunctions.PostProcess		Table	Any
AML.Execute		Text	Any
AccessControlEntry.ConditionToIdentities	Returns a list of identities that the condition will accept.	Function	List
Action.Return	Creates an action that performs no action when executed and returns the specified value as its result.	Any	Any
Action.Sequence	Creates an action that executes a sequence of actions in order.	List	Any
Action.Try	Creates an action that executes the specified action, catching and returning any errors that occur during its execution.	Any	Any
Action.View	Creates or extends an action with user-defined handlers for query and action operations.	Any	Any
Action.ViewError	Creates a modified error record which won’t trigger a fallback when thrown by a handler defined on a view (via Action.View).	Record	Record
Action.ViewFunction	Creates a function that can be intercepted by a handler defined on a view (via Binary.View).	Function	Function
Cube.AddAndExpandDimensionColumn	Merges the specified dimension table into the cube’s filter context and changes the dimensional granularity of the filter context by expanding the specified set of dimension attributes.	Table	Table
Cube.AddMeasureColumn	Adds a column to the cube that contains the results of the measure applied in the row context of each row.	Table	Table
Cube.ApplyParameter	Returns a cube after applying a parameter to it.	Table	Table
Cube.AttributeMemberId	Returns the unique member identifier from members property value.	Any	Any
Cube.AttributeMemberProperty	Returns a property of a dimension attribute.	Any	Any
Cube.CollapseAndRemoveColumns	Changes the dimensional granularity of the filter context for the cube by collapsing the attributes mapped to the specified columns.	Table	Table
Cube.Dimensions	Returns a table containing the set of available dimensions.	Table	Table
Cube.DisplayFolders	Returns a nested tree of tables representing the display folder hierarchy of the objects (for example, dimensions and measures).	Table	Table
Cube.MeasureProperties	Returns a table containing the set of available measure properties that are expanded in the cube.	Table	Table
Cube.MeasureProperty	Returns a property of a measure (cell property).	Any	Any
Cube.Measures	Returns a table containing the set of available measures.	Any	Table
Cube.Parameters	Returns a table containing the set of parameters that can be applied to the cube.	Table	Table
Cube.Properties	Returns a table containing the set of available properties for dimensions that are expanded in the cube.	Table	Table
Cube.PropertyKey	Returns the key of a property.	Any	Any
Cube.ReplaceDimensions	Replaces the set of dimensions returned by Cube.Dimensions.	Table	Table
Cube.Transform	Applies a list of cube functions.	Table	Table
ExcelTableInference.InferTables		Binary	Text
GetUserAccessTokens		Any	Any
Identity.From	Creates an identity.	Function	Record
Identity.IsMemberOf	Determines whether an identity is a member of an identity collection.	Record	Logical
IdentityProvider.Default	The default identity provider for the current host.	Any	Any
TableAction.DeleteRows	Creates an action to delete rows from a table.	Table	Any
TableAction.InsertRows	Creates an action to insert rows into a table.	Table	Any
TableAction.Tee	Creates an action that executes multiple actions concurrently while reading data from a table.	Table	Any
TableAction.UpdateRows	Creates an action to update rows in a table.	Table	Any
Value.ResourceExpression		Any	Any
ValueAction.BeginTransaction		Record	Any
ValueAction.CommitTransaction		Record	Any
ValueAction.NativeStatement	Creates an action to execute a statement against a target.	Any	Any
ValueAction.Replace	Creates an action that replaces the content of a value with the specified value.	Any	Any

Other Functions

Function	Description	Input	Output
FTP.Contents	Used to connect to FTP.	Text	Any
SFTP.Contents	Connect to SFTP	Text	Table

Power Platform Functions

Function	Description	Input	Output
AzureBatch.Contents	Connect to Azure Batch	Text	Any
AzureCostManagement.Contents		Text	Table
AzureCostManagement.Tables	Azure Cost Management	Text	Table
AzureDataExplorer.Contents	Imports data from Azure Data Explorer (Kusto)	Text	Table
AzureDataExplorer.Databases		Text	List
AzureDataFactory.Actions	Connect to Azure Data Factory Service	Text	Table
AzureDataFactoryDataFlow.Datasets		Text	Table
AzureDataFactoryDataFlow.GetDsl		Any	Any
AzureDataFactoryDataFlow.Validate		Any	Any
AzureDatabricksWorkspace.Actions	Connect to Azure Databricks workspace	Text	Any
AzureDevOpsServer.AccountContents	Enter Url of your Azure DevOps Analytics Service.	Text	Table
AzureDevOpsServer.AnalyticsViews	Enter organization and project names.	Text	Table
AzureDevOpsServer.Feed	Azure DevOps Services Feed	Text	Table
AzureDevOpsServer.Views	Enter organization and project names.	Text	Table
AzureEnterprise.Contents	Enter the URL of the Azure Enterprise REST API endpoint associated with your enrollment	Text	Binary
AzureEnterprise.Tables	Enter the URL of the Azure Enterprise REST API endpoint associated with your enrollment	Text	Table
AzureFunction.Contents	Connect to Azure Function	Text	Any
AzureHiveLLAP.Database	Import data from HDInsight Interactive Query	Text	Table
AzureKeyVault.Actions	Connect to Azure Keyvault Service	Text	Table
AzureMLFunctions.Contents		Any	Any
AzureMLFunctions.Execute		Text	Any
AzureMLFunctions.ExecuteBatch		Text	Any
AzureMachineLearning.Contents	Connect to AzureMachineLearning	Text	Any
AzureResourceGraph.Query		Text	Table
AzureSpark.Tables	List the tables in an Azure Spark instance.	Text	Table
AzureStorage.BlobContents	Returns the content of the specified blob from an Azure storage vault.	Text	Binary
AzureStorage.Blobs	Returns a navigational table containing the containers found in the specified account from an Azure storage vault.	Text	Table
AzureStorage.DataLake	Returns a navigational table containing the documents found in the specified container and its subfolders from Azure Data Lake Storage.	Text	Table
AzureStorage.DataLakeContents	Returns the content of the specified file from an Azure Data Lake Storage filesystem.	Text	Binary
AzureStorage.Tables	Returns a navigational table containing the tables found in the specified account from an Azure storage vault.	Text	Table
AzureSynapseWorkspace.Actions	Connect to Azure Synapse Service	Text	Table
AzureTimeSeriesInsights.Contents		Record	Table
AzureTrino.Contents		Text	Table
DataLake.Contents	Enter the URL of your Azure Data Lake Storage Gen1 account.	Text	Table
DataLake.Files	Enter the URL of your Azure Data Lake Storage account.	Text	Table
Databricks.Catalogs		Text	Table
Databricks.Contents		Text	Table
Databricks.Query		Text	Function
DatabricksMultiCloud.Catalogs		Text	Table
DatabricksMultiCloud.Query		Text	Function
Dataverse.DataLakes		Record	Any
DeltaLake.Table	Returns the contents of the Delta Lake table.	Table	Any
Fabric.Warehouse	Imports data from Warehouse	Record	Table
Lakehouse.Contents	Import data from a Lakehouse	Record	Table
Microsoft365.Contents	Used to connect to Microsoft 365.	Table	Table
MicrosoftAzureConsumptionInsights.Contents	Provide advanced query functions.	Any	Table
MicrosoftAzureConsumptionInsights.Tables	Microsoft Azure Consumption Insights	Any	Table
MicrosoftAzureConsumptionInsights.Test		Any	Any
MicrosoftGraphSecurity.Contents	Connector for the Microsoft Graph Security API	Text	Table

Last update: November 27, 2023 | Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/accessing-data-functions
© 2023 BI Gorilla. All rights reserved. Content derived from Microsoft documentation is property of Microsoft Corp.