DremioCloud.DatabasesByServer

DremioCloud.DatabasesByServer is a Power Query M function that retrieves a table containing information about the datasets available on the designated server within Dremio Cloud. The resulting table mirrors the datasets listed in the Power BI Navigator.

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

Syntax

DremioCloud.DatabasesByServer(
   server as text,
   optional projectId as nullable text,
   optional engine as nullable text,
) as table

Description

Returns a table listing the datasets on the specified server on Dremio Cloud. 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 a server on Dremio Cloud.

// Output: A table listing the datasets on a server.
DremioCloud.DatabasesByServer( "sql.dremio.cloud:443" )

Related functions

Other functions related to DremioCloud.DatabasesByServer are:

• DremioCloud.Databases
• DremioCloud.DatabasesByServerV330
• DremioCloud.DatabasesByServerV360

Contribute » | Contributors: Rick de Groot