Skip to Content

Wiki source code of Get data from Lakehouse

Version 1.1 by Dimitri Rupp on 2026/06/11 09:16
Show last authors
1 {{box cssClass="floatinginfobox" title="**Contents**"}}
2 {{toc/}}
3 {{/box}}
4
5 = 🔑 Get data from Lakehouse =
6
7 {{info}}
8 Data in Fabric can be accessed by connecting to shared workspace items such as **Lakehouses**, using permissions set by the admin team. Users can query data via supported endpoints with read access granted for specific items or tables. This article guides you through accessing Lakehouse tables using the **SQL endpoint**.
9 {{/info}}
10
11 == 🗺️ Workflow overview ==
12
13 {{mermaid}}
14 flowchart TD
15 subgraph ACCESS["🔐 Phase 1 · Access"]
16 S1[1 · Check your access]
17 S2[2 · Locate the Lakehouse]
18 S3[3 · Get connection string]
19 end
20 subgraph CONNECT["🔌 Phase 2 · Connect"]
21 S4[4 · Choose your tool]
22 S5[5 · Connect to endpoint]
23 S6[6 · Choose mode<br/>Import vs Direct Query]
24 end
25 subgraph USE["📊 Phase 3 · Use"]
26 S7[7 · Explore the tables]
27 S8[8 · Write queries with T-SQL]
28 S9[9 · Explore data & build reports]
29 end
30
31 S1 --> S2 --> S3 --> S4
32 S4 --> S5 --> S6 --> S7
33 S7 --> S8 --> S9
34
35 style S1 fill:#e8f1fa,stroke:#4472c4,stroke-width:2px
36 style S9 fill:#d4edda,stroke:#28a745,stroke-width:2px
37 style ACCESS fill:#fafafa,stroke:#888
38 style CONNECT fill:#fafafa,stroke:#888
39 style USE fill:#fafafa,stroke:#888
40 {{/mermaid}}
41
42 == Step 1 — Check your access ==
43
44 Access to a Lakehouse in Fabric is granted either through **workspace roles** or **direct sharing**. If you are assigned a role like Member or Viewer, you will see the workspace and can navigate to the Lakehouse directly. If the Lakehouse is shared with you individually, you will not see the workspace — use the link provided to access it. This link gives you access only to the shared item, and your permissions depend on what was granted.
45
46 == Step 2 — Locate the Lakehouse ==
47
48 Navigate to the Lakehouse from the workspace or via the shared link. Confirm that the Lakehouse loads successfully and that you can view its contents.
49
50 {{warning}}
51 You might be able to see all the schemas in the Lakehouse, but depending on your security role set by the Fabric team, tables and views might be unavailable. Contact the admins to change your access.
52 {{/warning}}
53
54 == Step 3 — Get connection string ==
55
56 To locate the SQL endpoint, go to **Home → Settings → SQL endpoint** and copy the string.
57
58 Alternatively, you can copy the SQL endpoint connection string directly from within the Lakehouse interface by clicking the **„Copy SQL connection string"** option located at the bottom-left corner of the screen.
59
60 == Step 4 — Choose your tool ==
61
62 Decide how you want to query the data — **Power BI**, **SQL Server Management Studio (SSMS)**, **Azure Data Studio**, or any tool that supports the **TDS protocol**.
63
64 == Step 5 — Connect to the endpoint ==
65
66 Use the SQL endpoint connection string to connect from your chosen tool. Authenticate using your organizational credentials when prompted.
67
68 {{info}}
69 **Tip:** Database name is the name of the Lakehouse. Use **SQL Server** as the connector in Power BI (Desktop and Dataflows).
70 {{/info}}
71
72 == Step 6 — Choose the mode ==
73
74 If you are connecting to the Lakehouse from Power BI Desktop, after you choose the tables you have the option to select between **Import** or **Direct Query**:
75
76 * **Import** — lets you download the selected tables to the model
77 * **Direct Query** — creates a live connection
78
79 == Step 7 — Explore the tables ==
80
81 Once connected, browse the database objects (tables, views) exposed via the SQL analytics endpoint. Only items you have permission for will be visible and accessible.
82
83 == Step 8 — Write queries ==
84
85 Use **T-SQL** to write queries against the tables. You can perform joins, filters, aggregations, and other analytical operations.
86
87 {{info}}
88 **Note:** In Power BI (Desktop and Dataflows), you can write queries in the **Advanced options** of the SQL Server connector (Step 5).
89 {{/info}}
90
91 == Step 9 — Explore data ==
92
93 Use the results for reporting, analysis, or export them to downstream tools like **Power BI** or **Excel**.
94
95 ----
96
97 {{info}}
98 **Migration note:** This page was migrated on 24.05.2026 from SharePoint WikiPowerBI into the Lumi-XWiki staging.
99
100 **Original author:** Bukkerji Sreejith (created and last modified 2025-10-10)
101 **Original source:** [[Get data from Lakehouse (SharePoint)>>url:https://spltele.sharepoint.com/sites/WikiPowerBI/SitePages/Get-data-from-Lakehouse.aspx]]
102 **Migration:** Dimitri Rupp via ClaudeAI
103
104 **Migration remarks:**
105 * Original language (English) preserved
106 * SharePoint 3-column step-card layout with decorative Hubble stock icons (purely decorative circles) converted to clean nine H2 sections — keeps full content, improves readability and accessibility
107 * **Mermaid flow overview** added at the top to visualise the 9-step sequence at a glance
108 * Note and Tip blocks rendered as XWiki info/warning boxes for emphasis
109 {{/info}}
110
111
112 ----
113
114 == Verwandte Themen ==
115
116 //Kuratiert — kann direkt im Editor ergänzt werden://
117
118 * [[FAQ>>doc:IT-Wiki.02-Tools.Fabric.FAQ.WebHome]]
119 * [[Fabric Notebooks>>doc:IT-Wiki.02-Tools.Fabric.Fabric-Notebooks.WebHome]]
120 * [[Fabric for power users>>doc:IT-Wiki.02-Tools.Fabric.Fabric-for-techies.WebHome]]
121
122 {{include reference="IT-Wiki.Makros.Verwandte-Themen.WebHome"/}}
123
124 ----
125 **Status:** Migriert — Team-Review ausstehend · **Owner:** //(festlegen)// · **Letzter Review:** 2026-06-11