Data warehousing documentation in Microsoft Fabric

Learn more about the two Data Warehousing experiences in Microsoft Fabric

Data warehousing

Overview

• Overview

Get started with Data Warehouse

Tutorial

• End to End tutorials
• Data warehouse tutorial
• Create a Warehouse quickstart

Get started with SQL Endpoint

Get Started

• What is a Lakehouse?
• Better together - the lakehouse and warehouse
• Create a lakehouse with OneLake
• Understand default Power BI datasets
• Load data into the Lakehouse
• How to copy data using Copy activity in Data pipeline
• How to move data into Lakehouse via Copy assistant

Security

How-To Guide

• Data warehousing security
• Connectivity
• Workspace roles
• SQL granular permissions
• Share your Warehouse

Ingest data

How-To Guide

• Ingest data guide
• Ingest data using pipelines
• Ingest data using TSQL
• Ingest data using Copy

Design and Develop

Concept

• Datasets
• Model data in the default Power BI dataset
• Define relationships in data models
• Reports in the Power BI service

Query

Concept

• Query using the SQL Query editor
• Query with T-SQL
• Query using visual query editor
• View data in the Data preview

Manage and Monitor

How-To Guide

• Monitor
• Capacity Metrics app
• Workload Management
• Statistics
• Troubleshoot

Best practices

Architecture

• Performance guidelines
• Security
• Ingest Data