DremioCloud.DatabasesByServerV370

Updated on

DremioCloud.DatabasesByServerV370 is a Power Query M function that returns a table listing the datasets on a specified server on Dremio Cloud.

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

Syntax

DremioCloud.DatabasesByServerV370(
   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,
   optional options as nullable record,
) 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.DatabasesByServerV370( "sql.dremio.cloud:443" )

Other functions related to DremioCloud.DatabasesByServerV370 are:

Contribute » | Contributors: Rick de Groot

2023-2024 © BI Gorilla. All rights are reserved. Information from Microsoft docs is property of Microsoft Corp. | Privacy Policy