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.
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 |