Accessing Data Functions Overview

Updated on

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

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

FunctionDescriptionInputOutput
Access.DatabaseReturns a structural representation of an Access database.BinaryTable
ActiveDirectory.DomainsReturns 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.TextTable
AnalysisServices.DatabaseReturns a table of multidimensional cubes or tabular models from the Analysis Services database.TextTable
AnalysisServices.DatabasesReturns the Analysis Services databases on a particular host.TextTable
CommonDataService.DatabaseTextTable
Csv.DocumentReturns the contents of the CSV document as a table.AnyTable
Excel.CurrentWorkbookReturns the contents of the current Excel workbook.TableTable
Excel.WorkbookReturns the contents of the Excel workbook.BinaryTable
Exchange.ContentsReturns a table of contents from a Microsoft Exchange account.TextTable
File.ContentsReturns the contents of the specified file as binary.TextBinary
Folder.ContentsReturns a table containing the properties and contents of the files and folders found in the specified folder.TextTable
Folder.FilesReturns a table containing the properties and contents of the files found in the specified folder and subfolders.TextTable
Html.TableReturns a table containing the results of running the specified CSS selectors against the provided HTML.AnyTable
Json.DocumentReturns the content of the JSON document.AnyAny
Json.FromValueProduces a JSON representation of a given value.AnyBinary
MySQL.DatabaseReturns a table of SQL tables, views, and stored scalar functions available in a MySQL database.TextTable
OData.FeedReturns a table of OData feeds offered by an OData service.TextAny
Odbc.DataSourceReturns a table of SQL tables and views from the ODBC data sourceAnyTable
Odbc.InferOptionsReturns the result of trying to infer SQL capabilities for an ODBC driver.AnyRecord
Odbc.QueryReturns the result of running a native query on an ODBC data source.AnyTable
OleDb.DataSourceReturns a table of SQL tables and views from the OLE DB data source.AnyTable
OleDb.QueryReturns the result of running a native query on an OLE DB data source.AnyTable
Oracle.DatabaseReturns a table of SQL tables and views from the Oracle database.TextTable
Parquet.DocumentReturns the contents of the Parquet document as a table.BinaryAny
Parquet.MetadataThis function is intended for internal use only.BinaryAny
Pdf.TablesReturns any tables found in a PDF file.BinaryTable
PostgreSQL.DatabaseReturns a table of SQL tables and views available in a PostgreSQL database.TextTable
PowerBI.DataflowsRecordTable
PowerBI.DatamartsImports data from DatamartsTextTable
PowerBIDatasets.ActionsConnect to PowerBIDatasetsTableTable
PowerPlatform.DataflowsImport data from a dataflowRecordTable
Python.ExecuteExecutes Python script and returns data framesTextTable
R.ExecuteTextTable
Resource.AccessAnyAny
SapHana.DatabaseReturns the packages in an SAP HANA database.TextTable
SharePoint.ContentsReturns a table containing content from a SharePoint site.TextTable
SharePoint.FilesReturns a table containing documents from a SharePoint site.TextTable
SharePoint.TablesReturns a table containing content from a SharePoint List.TextTable
Sql.DatabaseReturns a table of SQL tables, views, and stored functions from the SQL Server database.TextTable
Sql.DatabasesReturns a table of databases on a SQL Server.TextTable
Synapse.ContentsRecordTable
Web.ContentsReturns the contents downloaded from the url as binary.TextBinary
Web.HeadersReturns the HTTP headers downloaded from the url as a record value.TextRecord
Web.PageReturns 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.AnyTable
WebAction.RequestCreates an action that, when executed, will return the results of performing an HTTP request as a binary value.TextAny
Xml.DocumentReturns the contents of the XML document as a hierarchical table.AnyTable
Xml.TablesReturns the contents of the XML document as a nested collection of flattened tables.AnyTable

External Integrations

FunctionDescriptionInputOutput
AIInsights.ContentsAnyAny
AIInsights.ContentsGeneratorAnyAny
AML.ExecuteBatchTextAny
Acterys.ContentsAnyAny
Actian.ContentsTextAny
AdoDotNet.DataSourceReturns the schema collection for an ADO.NET data source.TextTable
AdoDotNet.QueryReturns the result of running a native query on an ADO.NET data source.TextTable
AdobeAnalytics.CubesReturns the report suites in Adobe Analytics.RecordTable
AmazonAthena.DatabasesTextTable
AmazonOpenSearchService.ContentsTextTable
AmazonRedshift.DatabaseImport data from an Amazon Redshift database.TextTable
AmazonS3.StorageUsed to connect to Amazon S3.TextTable
Anaplan.ContentsTextTable
ApacheHiveLLAP.DatabaseImport data from a Hive LLAPTextTable
ApacheSpark.TablesReturns a table listing the tables on the specified Spark cluster.TextTable
Asana.TablesTextTable
AssembleViews.ContentsTextTable
AssembleViews.FeedTextTable
AtScale.CubesImport/DirectQuery cube data from an AtScale.TextTable
AutodeskConstructionCloud.ContentsTextTable
AutodeskConstructionCloud.FeedTextTable
AutomationAnywhere.FeedTextTable
AutomyDataAnalytics.ContentsTableTable
BI360.ContentsTextTable
BIConnector.ContentsEnter connection informationTextTable
BQECore.ContentsAnyAny
BQL.QueryUsed for retrieving Bloomberg dataTextTable
BitSightSecurityRatings.ContentsTextAny
CDataConnectCloud.ContentsRecordTable
Cdm.ContentsThis function is unavailable because it requires .NET 4.5.TableTable
Cdm.MapToEntityReturns a table with columns mapped to the attributes of an entity in the Common Data Model, including data types.TableTable
Cdpa.DatabaseProvides access to a CDPA database.TextAny
Cds.ContentsTextAny
Cds.EntitiesTextTable
Celonis.KnowledgeModelsTextTable
Celonis.NavigationTextTable
Cherwell.SavedSearchesTextTable
CloudBluePSA.FeedTextTable
Cognite.ContentsTextTable
CosmosDB.ContentsTextTable
CustomerInsights.ContentsRecordTable
DB2.DatabaseReturns a table of SQL tables and views available in a Db2 database.TextTable
DCWInsights.FeedTextTable
DataLakeAnalytics.AccountConnect to Azure Data Lake Analytics accountTextTable
DataPipelineCosmosDb.ContentsUsed to connect to Azure CosmosDB with a data pipelineTextTable
DataVirtuality.DatabaseTextTable
DataWorld.ContentsTableTable
DataWorld.DatasetTextTable
DeltaSharing.ContentsTextTable
Denodo.ContentsTextTable
DocumentDB.ContentsEnter the URL of an Azure Cosmos DB account.TextTable
Dremio.DatabasesTextTable
Dremio.DatabasesV300TextTable
DremioCloud.DatabasesTextTable
DremioCloud.DatabasesByServerTextTable
DremioCloud.DatabasesByServerV330TextTable
DremioCloud.DatabasesByServerV360Returns a table listing the datasets on the specified server on Dremio CloudTextTable
Dynamics365BusinessCentral.ApiContentsEnter your Dynamics 365 Business Central environment and company.TextTable
Dynamics365BusinessCentral.ApiContentsWithOptionsEnter your Dynamics 365 Business Central environment and company.TextTable
Dynamics365BusinessCentral.ContentsEnter your Dynamics 365 Business Central environment and company.TextTable
Dynamics365BusinessCentral.EnvironmentContentsEnter your Dynamics 365 Business Central environment and company.TextTable
Dynamics365BusinessCentralOnPremises.ContentsEnter the URL of your Dynamics 365 Business Central (on-premises) OData service endpoint.TextTable
DynamicsNav.ContentsEnter the URL of your Dynamics NAV OData service endpoint.TextTable
EQuIS.ContentsTextTable
EduFrame.ContentsTextTable
ElasticSearch.DatabaseTextTable
Emigo.ContentsTextTable
Emigo.GetExtractFunctionTextAny
EmigoDataSourceConnector.GetExtractFunctionTextAny
EmplifiMetrics.ContentsRecordTable
EntersoftBusinessSuite.ContentsAnyAny
Essbase.CubesReturns the cubes in an Essbase instance grouped by Essbase server.TextTable
EventHub.ContentsUsed to connect to Azure Event Hub.TextTable
Exasol.DatabaseTextTable
FactSetAnalytics.AuthenticationCheckAnyAny
FactSetAnalytics.FunctionsTableTable
FactSetRMS.FunctionsRecordTable
Fhir.ContentsTextTable
Foundry.ContentsTextTable
Funnel.ContentsTableTable
Github.ContentsTextAny
Github.PagedTableTextAny
Github.TablesEnter the GitHub repository owner and the repository name.TextTable
GoogleAnalytics.AccountsReturns Google Analytics accounts.TableTable
GoogleBigQuery.DatabaseImport data from a Google BigQuery database.RecordTable
GoogleBigQueryAad.DatabaseImport data from a Google BigQuery database using Azure ADTextTable
GoogleCloudStorage.StorageUsed to connect to Google Cloud Storage.TextTable
GoogleSheets.ContentsImports data from GoogleSheetsTextTable
GraphDataset.ExtractMetadataAndContentsBinaryRecord
GraphDataset.FileSystemChangesTextAny
HdInsight.ContainersReturns a navigational table containing the containers found in the specified account from an Azure storage vault.TextTable
HdInsight.ContentsReturns a navigational table containing the containers found in the specified account from an Azure storage vault.TextTable
HdInsight.FilesReturns a table containing the properties and contents of the blobs found in the specified container from an Azure storage vault.TextTable
Hdfs.ContentsReturns a table containing the properties and contents of the files and folders found in the specified folder from a Hadoop file system.TextTable
Hdfs.FilesReturns a table containing the properties and contents of the files found in the specified folder and subfolders from a Hadoop file system.TextTable
HexagonSmartApi.ApplySelectListTextTable
HexagonSmartApi.ApplyUnitsOfMeasureTextAny
HexagonSmartApi.ExecuteParametricFilterOnFilterRecordTextAny
HexagonSmartApi.ExecuteParametricFilterOnFilterUrlTextAny
HexagonSmartApi.FeedTextTable
HexagonSmartApi.GenerateParametricFilterByFilterSourceTypeTextAny
HexagonSmartApi.GetODataMetadataTextAny
HexagonSmartApi.TypecastAnyFunction
IRIS.DatabaseTextTable
Impala.DatabaseImport data from an Impala clusterTextTable
Indexima.DatabaseTextTable
IndustrialAppStore.NavigationTableTableTable
InformationGrid.ContentsTextTable
Informix.DatabaseReturns a table of SQL tables and views available in an Informix database.TextTable
Intune.ContentsNumberTable
IoTHub.ContentsUsed to connect to Azure IoT Hub.TextTable
JamfPro.ContentsTextAny
JethroODBC.DatabaseTextTable
Kognitwin.ContentsTextTable
Kusto.ContentsImports data from Azure Data Explorer (Kusto)TextTable
Kusto.DatabasesTextList
Kyligence.DatabaseTextTable
Linkar.ContentsTextTable
LinkedIn.SalesContractsTableTable
LinkedIn.SalesContractsWithReportAccessTableTable
LinkedIn.SalesNavigatorTextTable
LinkedIn.SalesNavigatorAnalyticsTextTable
LinkedIn.SalesNavigatorAnalyticsImplTextAny
MQ.QueueReturns a table of messages available in the queue via a non-destructive read.TextTable
MailChimp.CollectionReturns a table with data from a MailChimp endpoint.TextTable
MailChimp.InstanceReturns raw response results from a MailChimp API endpoint.TextTable
MailChimp.TablesTableTable
MailChimp.TablesV2Returns a table with key MailChimp data.TableTable
MariaDB.ContentsTextTable
MarkLogicODBC.ContentsTextTable
Marketo.ActivitiesReturns a table with lead activities.TextTable
Marketo.LeadsReturns a table with lead details.TextTable
Marketo.TablesEnter the URL of the Marketo REST API endpoint associated with your account.TextTable
MicroStrategyDataset.ContentsTextTable
MicroStrategyDataset.TestConnectionTextAny
Mixpanel.ContentsTextAny
Mixpanel.ExportTextAny
Mixpanel.FunnelByIdNumberAny
Mixpanel.FunnelByNameTextAny
Mixpanel.FunnelsAnyAny
Mixpanel.SegmentationTextAny
Mixpanel.TablesAnyAny
MongoDBAtlasForPipeline.DatabaseConnect to MongoDB Atlas For PipelineTextAny
MongoDBAtlasODBC.ContentsTextTable
MongoDBAtlasODBC.QueryTextTable
MongoDBForPipeline.ContentsUsed to connect to MongoDB For Pipeline.TextAny
Netezza.DatabaseImport data from an IBM Netezza database.TextTable
OpenSearchProject.ContentsTextTable
OracleERP.ContentsTextAny
Paxata.ContentsTextTable
PlanviewEnterprise.CallQueryServiceEnter the URL, database name associated with your Planview Portfolios account and a SQL query.TextTable
PlanviewEnterprise.FeedEnter the URL and database name associated with your Planview Portfolios account.TextTable
PlanviewOKR.ContentsEnter the URL of your Planview OKR account.TextTable
PlanviewProjectplace.ContentsEnter the URL of your Planview Projectplace account.TextTable
ProductInsights.ContentsTableTable
ProductInsights.QueryMetricTextAny
Profisee.TablesTextTable
Projectplace.FeedEnter the URL of your Planview Projectplace account.TextTable
QubolePresto.ContentsTextAny
QuickBase.ContentsTextTable
QuickBooks.QueryTextTable
QuickBooks.ReportTextTable
QuickBooks.TablesAnyAny
QuickBooksOnline.TablesImport data from QuickBooks Online.RecordTable
RData.FromBinaryReturns a record of data frames from the RData file.BinaryAny
Roamler.ContentsAnyAny
SAPERP.FunctionsImport data from SAP RFCsTextTable
SDMX.ContentsTextTable
Salesforce.DataReturns the objects from the Salesforce account.AnyTable
Salesforce.ReportsReturns the reports from the Salesforce account.TextTable
SapBusinessWarehouse.CubesReturns the InfoCubes and queries in an SAP Business Warehouse system grouped by InfoArea.TextTable
ShortcutsBI.ContentsTableTable
SingleStoreODBC.DataSourceTextTable
SingleStoreODBC.DatabaseTextTable
SingleStoreODBC.QueryTextTable
Siteimprove.ContentsTableTable
Smartsheet.ContentReturns a table of data from an Smartsheet index endpoint.TextAny
Smartsheet.QueryReturns a JSON result from the Smartsheet APITextAny
Smartsheet.TablesReturns a table of sheets, reports, folders, and workspaces from the Smartsheet APITableTable
Snowflake.DatabasesImport data from a Snowflake Computing warehouse.TextTable
SocialbakersMetrics.ContentsRecordTable
Soda.FeedReturns a table from the contents at the specified URL formatted according to the SODA 2.0 API.TextTable
SoftOneBI.ContentsTableTable
SolarWindsServiceDesk.ContentsAnyAny
SolarWindsServiceDesk.TestContentsAnyAny
Spark.TablesReturns a table listing the tables on the specified Spark cluster.TextTable
SparkPost.GetListTextTable
SparkPost.GetTableReturns a table of available metrics from the SparkPost API v1NumberTable
SparkPost.NavTableNumberTable
Spigit.ContentsEnter the URL of your Planview IdeaPlace account.TextTable
StarburstPresto.ContentsTextTable
Stripe.ContentsMakes a call to the Stripe API, with the option to limit number of API calls made.TextTable
Stripe.MethodMakes a call to the Stripe API.TextTable
Stripe.TablesReturns a table listing the available Stripe tables and functions.TableTable
SumTotal.ODataFeedTextTable
SurveyMonkey.ContentsTableTable
SweetIQ.ContentsTextAny
SweetIQ.TablesAnyAny
Sybase.DatabaseReturns a table of SQL tables and views available in a Sybase database.TextTable
TeamDesk.DatabaseTextTable
TeamDesk.SelectTextTable
TeamDesk.SelectViewTextTable
TeamsAnalytics.ContentsTableTable
Tenforce.ContentsTextTable
Teradata.DatabaseReturns a table of SQL tables and views from the Teradata database.TextTable
TibcoTdv.DataSourceTextTable
TimeSeriesInsights.ContentsRecordTable
TridentPipelines.ApplyUserAnyAny
TridentPipelines.CancelExecutionAnyAny
TridentPipelines.CreateAnyAny
TridentPipelines.CreateDataFactoryAnyAny
TridentPipelines.DeleteAnyAny
TridentPipelines.ExecuteAnyAny
TridentPipelines.GetDataFactoryAnyAny
TridentPipelines.GetExecutionStatusAnyAny
TridentPipelines.ServiceAnyAny
TridentPipelines.UserAnyAny
Troux.CustomFeedEnter the URL of your Planview Enterprise Architecture account and a query.TextTable
Troux.FeedEnter the URL of your Planview Enterprise Architecture account.TextTable
Troux.TestConnectionTextAny
Twilio.ContentsAnyAny
Twilio.TablesEnter the number of months of historical Twilio data to retrieve.NumberTable
Twilio.URLAnyAny
Usercube.UniversesTextTable
VSTS.AccountContentsEnter Url of your Azure DevOps Analytics Service.TextTable
VSTS.AnalyticsViewsEnter organization and project names.TextTable
VSTS.ContentsEnter Url of your Azure DevOps Analytics Service.TextTable
VSTS.FeedAzure DevOps Services FeedTextTable
VSTS.ViewsEnter organization and project names.TextTable
Vena.ContentsTextTable
Vertica.DatabaseImport data from VerticaTextTable
VesselInsight.ContentsAnyAny
VivaInsights.DataTextTable
Web.BrowserContentsReturns the HTML for the specified URL, as viewed by a web browser.TextText
WebForPipeline.ContentsConnect to Web V2TextTable
Webtrends.KeyMetricsReturns a table with key Webtrends metrics.TextTable
Webtrends.ProfileAnyAny
Webtrends.ReportContentsReturns a table with report content from Webtrends.TextTable
Webtrends.TablesEnter the Profile ID associated with your Webtrends account.TextTable
WebtrendsAnalytics.TablesEnter the Profile ID associated with your Webtrends account.TextTable
Witivio.ContentsTextTable
WorkforceDimensions.ContentsTextText
WorkplaceAnalytics.DataTextTable
Wrike.ContentsTableTable
Zendesk.CollectionAnyAny
Zendesk.TablesEnter the URL of your Zendesk account.TextTable
ZohoCreator.ContentsTextAny
Zucchetti.ContentsTextTable
appFigures.ContentTextAny
appFigures.TablesTableTable
eWayCRM.ContentsLogicalTable

Operations

FunctionDescriptionInputOutput
AI.ExecuteInProcTextAny
AI.ExecuteInternalTextAny
AI.ExternalSortTableAny
AI.GetAutoMLEntityTextAny
AI.SampleStratifiedWithHoldoutTextAny
AI.TestConnectionAnyAny
AIFunctions.CapacitiesAnyAny
AIFunctions.ContentsAnyAny
AIFunctions.ExecuteInternalTextAny
AIFunctions.GetAutoMLEntityTextAny
AIFunctions.PostProcessTableAny
AML.ExecuteTextAny
AccessControlEntry.ConditionToIdentitiesReturns a list of identities that the condition will accept.FunctionList
Action.ReturnCreates an action that performs no action when executed and returns the specified value as its result.AnyAny
Action.SequenceCreates an action that executes a sequence of actions in order.ListAny
Action.TryCreates an action that executes the specified action, catching and returning any errors that occur during its execution.AnyAny
Action.ViewCreates or extends an action with user-defined handlers for query and action operations.AnyAny
Action.ViewErrorCreates a modified error record which won’t trigger a fallback when thrown by a handler defined on a view (via Action.View).RecordRecord
Action.ViewFunctionCreates a function that can be intercepted by a handler defined on a view (via Binary.View).FunctionFunction
Cube.AddAndExpandDimensionColumnMerges 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.TableTable
Cube.AddMeasureColumnAdds a column to the cube that contains the results of the measure applied in the row context of each row.TableTable
Cube.ApplyParameterReturns a cube after applying a parameter to it.TableTable
Cube.AttributeMemberIdReturns the unique member identifier from members property value.AnyAny
Cube.AttributeMemberPropertyReturns a property of a dimension attribute.AnyAny
Cube.CollapseAndRemoveColumnsChanges the dimensional granularity of the filter context for the cube by collapsing the attributes mapped to the specified columns.TableTable
Cube.DimensionsReturns a table containing the set of available dimensions.TableTable
Cube.DisplayFoldersReturns a nested tree of tables representing the display folder hierarchy of the objects (for example, dimensions and measures).TableTable
Cube.MeasurePropertiesReturns a table containing the set of available measure properties that are expanded in the cube.TableTable
Cube.MeasurePropertyReturns a property of a measure (cell property).AnyAny
Cube.MeasuresReturns a table containing the set of available measures.AnyTable
Cube.ParametersReturns a table containing the set of parameters that can be applied to the cube.TableTable
Cube.PropertiesReturns a table containing the set of available properties for dimensions that are expanded in the cube.TableTable
Cube.PropertyKeyReturns the key of a property.AnyAny
Cube.ReplaceDimensionsReplaces the set of dimensions returned by Cube.Dimensions.TableTable
Cube.TransformApplies a list of cube functions.TableTable
ExcelTableInference.InferTablesBinaryText
GetUserAccessTokensAnyAny
Identity.FromCreates an identity.FunctionRecord
Identity.IsMemberOfDetermines whether an identity is a member of an identity collection.RecordLogical
IdentityProvider.DefaultThe default identity provider for the current host.AnyAny
TableAction.DeleteRowsCreates an action to delete rows from a table.TableAny
TableAction.InsertRowsCreates an action to insert rows into a table.TableAny
TableAction.TeeCreates an action that executes multiple actions concurrently while reading data from a table.TableAny
TableAction.UpdateRowsCreates an action to update rows in a table.TableAny
Value.ResourceExpressionAnyAny
ValueAction.BeginTransactionRecordAny
ValueAction.CommitTransactionRecordAny
ValueAction.NativeStatementCreates an action to execute a statement against a target.AnyAny
ValueAction.ReplaceCreates an action that replaces the content of a value with the specified value.AnyAny

Other Functions

FunctionDescriptionInputOutput
FTP.ContentsUsed to connect to FTP.TextAny
SFTP.ContentsConnect to SFTPTextTable

Power Platform Functions

FunctionDescriptionInputOutput
AzureBatch.ContentsConnect to Azure BatchTextAny
AzureCostManagement.ContentsTextTable
AzureCostManagement.TablesAzure Cost ManagementTextTable
AzureDataExplorer.ContentsImports data from Azure Data Explorer (Kusto)TextTable
AzureDataExplorer.DatabasesTextList
AzureDataFactory.ActionsConnect to Azure Data Factory ServiceTextTable
AzureDataFactoryDataFlow.DatasetsTextTable
AzureDataFactoryDataFlow.GetDslAnyAny
AzureDataFactoryDataFlow.ValidateAnyAny
AzureDatabricksWorkspace.ActionsConnect to Azure Databricks workspaceTextAny
AzureDevOpsServer.AccountContentsEnter Url of your Azure DevOps Analytics Service.TextTable
AzureDevOpsServer.AnalyticsViewsEnter organization and project names.TextTable
AzureDevOpsServer.FeedAzure DevOps Services FeedTextTable
AzureDevOpsServer.ViewsEnter organization and project names.TextTable
AzureEnterprise.ContentsEnter the URL of the Azure Enterprise REST API endpoint associated with your enrollmentTextBinary
AzureEnterprise.TablesEnter the URL of the Azure Enterprise REST API endpoint associated with your enrollmentTextTable
AzureFunction.ContentsConnect to Azure FunctionTextAny
AzureHiveLLAP.DatabaseImport data from HDInsight Interactive QueryTextTable
AzureKeyVault.ActionsConnect to Azure Keyvault ServiceTextTable
AzureMLFunctions.ContentsAnyAny
AzureMLFunctions.ExecuteTextAny
AzureMLFunctions.ExecuteBatchTextAny
AzureMachineLearning.ContentsConnect to AzureMachineLearningTextAny
AzureResourceGraph.QueryTextTable
AzureSpark.TablesList the tables in an Azure Spark instance.TextTable
AzureStorage.BlobContentsReturns the content of the specified blob from an Azure storage vault.TextBinary
AzureStorage.BlobsReturns a navigational table containing the containers found in the specified account from an Azure storage vault.TextTable
AzureStorage.DataLakeReturns a navigational table containing the documents found in the specified container and its subfolders from Azure Data Lake Storage.TextTable
AzureStorage.DataLakeContentsReturns the content of the specified file from an Azure Data Lake Storage filesystem.TextBinary
AzureStorage.TablesReturns a navigational table containing the tables found in the specified account from an Azure storage vault.TextTable
AzureSynapseWorkspace.ActionsConnect to Azure Synapse ServiceTextTable
AzureTimeSeriesInsights.ContentsRecordTable
AzureTrino.ContentsTextTable
DataLake.ContentsEnter the URL of your Azure Data Lake Storage Gen1 account.TextTable
DataLake.FilesEnter the URL of your Azure Data Lake Storage account.TextTable
Databricks.CatalogsTextTable
Databricks.ContentsTextTable
Databricks.QueryTextFunction
DatabricksMultiCloud.CatalogsTextTable
DatabricksMultiCloud.QueryTextFunction
Dataverse.DataLakesRecordAny
DeltaLake.TableReturns the contents of the Delta Lake table.TableAny
Fabric.WarehouseImports data from WarehouseRecordTable
Lakehouse.ContentsImport data from a LakehouseRecordTable
Microsoft365.ContentsUsed to connect to Microsoft 365.TableTable
MicrosoftAzureConsumptionInsights.ContentsProvide advanced query functions.AnyTable
MicrosoftAzureConsumptionInsights.TablesMicrosoft Azure Consumption InsightsAnyTable
MicrosoftAzureConsumptionInsights.TestAnyAny
MicrosoftGraphSecurity.ContentsConnector for the Microsoft Graph Security APITextTable
BI Gorilla Blog

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/accessing-data-functions