Dremio.DatabasesV300

Updated on

Dremio.DatabasesV300 is a Power Query M function that returns a table listing the datasets on Dremio Server, equivalent to the list shown in Power BI Navigator.

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

Syntax

Dremio.DatabasesV300(
   server as text,
   encryption 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 with an encrypted connection.

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

Other functions related to Dremio.DatabasesV300 are:

Contribute » | Contributors: Rick de Groot