DremioCloud.DatabasesByServer

Syntax

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

Remarks

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

Example #1

How to return the list of datasets on a server on Dremio Cloud.

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

Result:

A table listing the datasets on a server.