Fabric SQL Analytics endpoint

The OneLake.SqlAnalytics function imports data from the SQL Analytics endpoint of a Fabric Item.

Summary

Property Value
Connector Fabric SQL Analytics endpoint icon 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