Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
This reference describes the Dremio Software connector metadata and supported capabilities, including connection parameters.
Summary
| Property | Value |
|---|---|
| Connector |  Dremio Software |
| Products | Power BI (semantic models) Power Query Online |
| Release state | General availability |
| Category | Database |
| Authentication kinds | Microsoft Entra ID Username/Password |
| Data source kind | Dremio |
| Function Reference Documentation | Dremio.DatabasesDremio.DatabasesV300Dremio.DatabasesV370 |
Supported capabilities
- Import
- DirectQuery
Parameters
Entry point: Dremio.DatabasesV370
Required parameter count: 2
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/powerquery-m/odbc-datasource
| Parameter | Display name | Required | Type | Description | Allowed values | Sample values | Nullable | Declared allowed values |
|---|---|---|---|---|---|---|---|---|
| server | Dremio Server | Yes | text | "servername:31010" | false | |||
| encryption | Encryption | Yes | text | Encryption must be enabled if connecting direct from PBI Service | "Enabled"; "Disabled"; "Enabled-PEM" | false | ["Enabled", "Disabled", "Enabled-PEM"] | |
| engine | Engine | No | nullable text | The name of engine on which to run the query. If you do not specify an engine, Dremio will auto-select an engine based on the project’s Engine Routing rules. | "engine" | true | ||
| routingTag | Tag | No | nullable text | Used for workload management | "tag" | true | ||
| routingQueue | Queue | No | nullable text | Used for workload management | "queue" | true | ||
| options | No | nullable record | true |