Zum Hauptinhalt springen

Dremio.DatabasesV300

Syntax

Dremio.DatabasesV300(
server as text,
encryption as text,
optional engine as text,
optional routingTag as text,
optional routingQueue as text
) as table

Remarks

Returns a table listing the datasets on Dremio Server. 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 localhost with an encrypted connection.

Dremio.DatabasesV300("localhost:31010","Enabled")

Result:

A table listing the datasets on localhost.