Pastaba.
Prieigai prie šio puslapio reikalingas įgaliojimas. Galite bandyti prisijungti arba pakeisti katalogus.
Prieigai prie šio puslapio reikalingas įgaliojimas. Galite bandyti pakeisti katalogus.
The OneLake.SqlAnalytics function imports data from the SQL Analytics endpoint of a Fabric Item.
Summary
| Property | Value |
|---|---|
| Connector |  Fabric SQL Analytics endpoint |
| Products | Power BI (semantic models) Power Query Online |
| Release state | Preview |
| Category | Fabric |
| Authentication kinds | Microsoft Entra ID |
| Data source kind | OneLakeSql |
| Function Reference Documentation | OneLake.SqlAnalytics |
Supported capabilities
Entry point: OneLake.SqlAnalytics
- DirectQuery
Parameters
Entry point: OneLake.SqlAnalytics
Required parameter count: 3
Imports data from Fabric SQL Analytics endpoint
Imports data from the SQL Analytics endpoint of a Fabric Item
| Parameter | Display name | Required | Type | Sample values | Nullable |
|---|---|---|---|---|---|
| workspace | Workspace Id | Yes | text | "85599f29-c009-4253-b53b-c3ba6e4afa97" | false |
| database | Database Name | Yes | text | "mySqlAnalyticsDatabase" | false |
| artifactType | Item Type | Yes | text | "Lakehouse" | false |
| options | Options | No | nullable record | "[ ConnectionTimeout = 0 ]" | true |