Updated on

DocumentDB.Contents is a Power Query M function that returns a table of Azure Cosmos DB databases, providing optional database and query specification.

Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365


   url as text,
   optional database as nullable text,
   optional collection as nullable text,
   optional options as nullable record,
) as table


Returns a table of Azure Cosmos DB databases at url. If database is specified, a table of collections will be returned instead. Additionally, if the field Query is specified in the options record the results of the query being executed on either the specified database and/or collection will be returned.

Other functions related to DocumentDB.Contents are:

Contribute » | Contributors: Rick de Groot