M365 Show -  Microsoft 365 Digital Workplace Daily

M365 Show - Microsoft 365 Digital Workplace Daily

Microsoft Data Pulse: Power BI, Fabric, Purview

How to Use Create Table AS in Microsoft Fabric for Fast Data Loading

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

You can use the create table as statement, or CTAS, to quickly ingest data in Microsoft Fabric. This tool lets you build a new table from a select query, which means you move data from one layer to another with speed and control. When you ingest data, you often need to create a new table for your silver or gold layers. CTAS helps you accelerate data ing…

Keep reading with a 7-day free trial

Subscribe to M365 Show - Microsoft 365 Digital Workplace Daily to keep reading this post and get 7 days of free access to the full post archives.

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