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 tableDescription
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" )Related functions
Other functions related to DremioCloud.Databases are:
