M365 Show -  Microsoft 365 Digital Workplace Daily

M365 Show - Microsoft 365 Digital Workplace Daily

Microsoft Data Pulse: Power BI, Fabric, Purview

Effortless Table Creation in Fabric SQL Using SELECT INTO

Mirko Peters - M365 Specialist's avatar
Mirko Peters - M365 Specialist
Jul 08, 2025
∙ Paid

You want to create a table in Fabric SQL, but you notice that the common CREATE TABLE AS command does not work in Microsoft Fabric. This can cause confusion, especially if you come from other SQL backgrounds. In Microsoft Fabric, SELECT INTO is the method you need for table creation. You can use SELECT INTO to create tables quickly and easily. This appr…

This post is for paid subscribers

Already a paid subscriber? Sign in
© 2025 Mirko Peters
Publisher Privacy ∙ Publisher Terms
Substack
Privacy ∙ Terms ∙ Collection notice
Start your SubstackGet the app
Substack is the home for great culture