Dremio.DatabasesV300 is a Power Query M function that returns a table listing the datasets on Dremio Server, equivalent to the list shown in Power BI Navigator.
Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365
Syntax
Dremio.DatabasesV300(
server as text,
encryption as text,
optional engine as nullable text,
optional routingTag as nullable text,
optional routingQueue as nullable text,
) as tableDescription
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
How to return the list of datasets on localhost with an encrypted connection.
// Output: A table listing the datasets on localhost.
Dremio.DatabasesV300( "localhost:31010","Enabled" )Related functions
Other functions related to Dremio.DatabasesV300 are:
