Dremio.DatabasesV370

Updated on

Dremio.DatabasesV370 is a Power Query M function that returns a table listing the datasets on Dremio Server.

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

Syntax

Dremio.DatabasesV370(
   server as text,
   encryption as text,
   optional engine as nullable text,
   optional routingTag as nullable text,
   optional routingQueue as nullable text,
   optional options as nullable record,
) 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.

Dremio.DatabasesV370( "localhost:31010","Enabled" )

Other functions related to Dremio.DatabasesV370 are:

Contribute » | Contributors: Rick de Groot