Wiki source code of Get data from Lakehouse
Last modified by Dimitri Rupp on 2026/06/11 09:30
Show last authors
| author | version | line-number | content |
|---|---|---|---|
| 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 | == Verwandte Themen == | ||
| 98 | |||
| 99 | //Kuratiert — kann direkt im Editor ergänzt werden:// | ||
| 100 | |||
| 101 | * [[FAQ>>doc:IT-Wiki.02-Tools.Fabric.FAQ.WebHome]] | ||
| 102 | * [[Fabric Notebooks>>doc:IT-Wiki.02-Tools.Fabric.Fabric-Notebooks.WebHome]] | ||
| 103 | * [[Fabric for power users>>doc:IT-Wiki.02-Tools.Fabric.Fabric-for-techies.WebHome]] | ||
| 104 | |||
| 105 | {{include reference="IT-Wiki.Makros.Verwandte-Themen.WebHome"/}} | ||
| 106 | |||
| 107 | ---- | ||
| 108 | **Status:** Migriert — Team-Review ausstehend · **Owner:** //(festlegen)// · **Letzter Review:** 2026-06-11 |