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 FabricSql.Contents function imports data from SQL database items in Fabric.
Summary
| Property | Value |
|---|---|
| Connector |  SQL database in Fabric |
| Products | Power BI (semantic models) Power Query Online |
| Release state | Preview |
| Category | Fabric |
| Authentication kinds | Microsoft Entra ID |
| Data source kind | FabricSql |
| Function Reference Documentation | FabricSql.Contents |
Supported capabilities
Entry point: FabricSql.Contents
- DirectQuery
Parameters
Entry point: FabricSql.Contents
Required parameter count: 0
Import data from SQL database items in Fabric
| Parameter | Required | Type | Nullable |
|---|---|---|---|
| options | No | nullable record | true |
Fields in options
| Field | Display name | Required | Type | Nullable | Optional |
|---|---|---|---|---|---|
| options.HierarchicalNavigation | Navigate using full hierarchy (enables schema support) | No | logical | false | true |