Dremio.Databases

Updated on

Dremio.Databases is a Power Query M function that returns a table listing the datasets on Dremio Server. This corresponds to the list shown in Power BI Navigator.

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

Syntax

Dremio.Databases(
   server as text,
   optional engine as nullable text,
   optional routingTag as nullable text,
   optional routingQueue as nullable text,
) as table

Description

Returns a table listing the datasets on Dremio Server. This will be the same list as shown in Power BI Navigator. See https://docs.microsoft.com/en-us/powerquery-m/odbc-datasource

Examples

How to return the list of datasets on localhost. This uses the default encrypted connection.

// Output: A table listing the datasets on localhost.
Dremio.Databases( "localhost:31010" )

Other functions related to Dremio.Databases are:

Contribute » | Contributors: Rick de Groot