DremioCloud.DatabasesByServerV360

Updated on

DremioCloud.DatabasesByServerV360 is a Power Query M function that retrieves a table listing the datasets available on a specified server in Dremio Cloud, matching the Power BI Navigator list.

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

Syntax

DremioCloud.DatabasesByServerV360(
   server as text,
   optional projectId as nullable text,
   optional engine as nullable text,
   optional routingTag as nullable text,
   optional routingQueue as nullable text,
   optional encryption 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.

DremioCloud.DatabasesByServerV360( "sql.dremio.cloud:443" )

Other functions related to DremioCloud.DatabasesByServerV360 are:

BI Gorilla Blog

Contribute » | Contributors: Rick de Groot