BP
BPS-Corp
DBA Tools & Training
← All courses

Connect Microsoft Fabric to SSMS

Open your company's Fabric data in SSMS - find the SQL endpoint, sign in with your work account, and run your first query. A hands-on, ~5-minute course for business analysts, no coding needed.

Sign in to start this course. Sign in

A Fabric warehouse or lakehouse is also a normal SQL database you can open with tools you already know. In five short, hands-on videos you'll find the SQL analytics endpoint inside Fabric, install SSMS 22, connect with your Microsoft Entra work login (no database password), and run your first query against the warehouse - then read and save the results. Prerequisites: a work account that signs into Fabric, SSMS 22 (covered in the course), and read access to at least one Fabric warehouse or lakehouse.

Why, and what to copy

  • ○ Why bother Video
  • ○ Find your connection details Video

Get into SSMS

  • ○ Get and open SSMS 22 Video
  • ○ Connect with your work login Video

Run a query

  • ○ Run your first query Video
  • ○ Course quiz Quiz