إشعار
يتطلب الوصول إلى هذه الصفحة تخويلاً. يمكنك محاولة تسجيل الدخول أو تغيير الدلائل.
يتطلب الوصول إلى هذه الصفحة تخويلاً. يمكنك محاولة تغيير الدلائل.
Summary
| Property | Value |
|---|---|
| Connector |  Dremio Cloud |
| Products | Power BI (semantic models) Power Query Online |
| Release state | General availability |
| Category | Database |
| Authentication kinds | Microsoft Entra ID Personal Access Token |
| Data source kind | DremioCloud |
| Function Reference Documentation | DremioCloud.DatabasesDremioCloud.DatabasesByServerDremioCloud.DatabasesByServerV330DremioCloud.DatabasesByServerV360DremioCloud.DatabasesByServerV370 |
| Support link | Support |
Supported capabilities
Entry point: DremioCloud.DatabasesByServerV370
- DirectQuery
Parameters
Entry point: DremioCloud.DatabasesByServerV370
Required parameter count: 1
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/powerquery-m/odbc-datasource
| Parameter | Display name | Required | Type | Description | Allowed values | Sample values | Nullable | Declared allowed values |
|---|---|---|---|---|---|---|---|---|
| server | Server | Yes | text | Server is sql.dremio.cloud for Dremio Cloud US, sql.eu.dremio.cloud for Dremio Cloud Europe or <coordinator>:31010 for Dremio Software | "sql.dremio.cloud" | false | ||
| projectId | Project | No | nullable text | The UUID of the project. You can find this on the Project Settings > General Information page. (Dremio Cloud only) | "xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx" | true | ||
| 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 | An arbitrary tag that you can refer to in Queue Routing rules. (Dremio Software only) | "tag" | true | ||
| routingQueue | Queue | No | nullable text | The name of the queue to which this query should be assigned. If you do not specify a queue, Dremio will auto-select a queue based on the Queue Routing rules. (Dremio Software only) | "queue" | true | ||
| encryption | Trusted certificates location | No | nullable text | Alternative location of trusted certificates if not using the default system trust store | "Enabled-PEM" | true | ["Enabled-PEM"] | |
| options | No | nullable record | true |