DremioCloud.DatabasesByServer is a Power Query M function that retrieves a table containing information about the datasets available on the designated server within Dremio Cloud. The resulting table mirrors the datasets listed in the Power BI Navigator.
Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365
Syntax
DremioCloud.DatabasesByServer(
server as text,
optional projectId as nullable text,
optional engine as nullable text,
) as tableDescription
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.
// Output: A table listing the datasets on a server.
DremioCloud.DatabasesByServer( "sql.dremio.cloud:443" )Related functions
Other functions related to DremioCloud.DatabasesByServer are:
