DremioCloud.DatabasesByServerV330

Updated on

DremioCloud.DatabasesByServerV330 is a Power Query M function that returns a table listing the datasets on a specified server on Dremio Cloud. This mirrors the list shown in Power BI Navigator.

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

Syntax

DremioCloud.DatabasesByServerV330(
   server as text,
   optional projectId as nullable 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 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.DatabasesByServerV330( "sql.dremio.cloud:443" )

Other functions related to DremioCloud.DatabasesByServerV330 are:

BI Gorilla Blog

Contribute » | Contributors: Rick de Groot