DremioCloud.Databases

Updated on

DremioCloud.Databases is a Power Query M function that lists the datasets in a specified project on Dremio Cloud, corresponding to the list shown in Power BI Navigator. This function is maintained for backward compatibility with previous connector versions of Dremio Cloud.

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

Syntax

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

Description

Returns a table listing the datasets in the specified project 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. This function is maintained for backward compatibility with previous connector versions of Dremio Cloud.

Examples

How to return the list of datasets in project, xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx, on Dremio Cloud.

// Output: A table listing the datasets in project, xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx.
DremioCloud.Databases( "xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx" )

Other functions related to DremioCloud.Databases are:

BI Gorilla Youtube Channel

Contribute » | Contributors: Rick de Groot