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…

User's avatar

Continue reading this post for free, courtesy of Mirko Peters - M365 Specialist.

Or purchase a paid subscription.
© 2026 Mirko Peters · Publisher Privacy ∙ Publisher Terms
Substack · Privacy ∙ Terms ∙ Collection notice
Start your SubstackGet the app
Substack is the home for great culture