Looking for a free tool to import tables from DirectLike over OneLake model?

[jaryszek]

Hello,

I know that Tabular Editor 3 (paid one) has option to import new tables into existing semantic model based on OneLake. 

But maybe there are free tools to achive the same?

Best,
Jacek

[v-lgarikapat]

Hi @jaryszek ,

Thanks for reaching out to the Microsoft fabric community forum.

Fabric Dataflow Gen2

• A free, visual ETL tool within Microsoft Fabric.
• Allows you to transform and load data into OneLake, which can then be surfaced in semantic models.
• Ideal for business users and data engineers.

T-SQL COPY INTO

• If you're comfortable with SQL, you can use the COPY INTO command to load data directly into OneLake.
• This method is free and works well for structured data ingestion.

If you have any further questions or need assistance, please feel free to let us know.

We appreciate your engagement and thank you for being an active part of the community.

Best Regards,

Lakshmi

[jaryszek]

Thank you, 

"

• If you're comfortable with SQL, you can use the COPY INTO command to load data directly into OneLake."
  
  What tool can I use fot that? 

[v-lgarikapat · Accepted solution]

Hi @jaryszek ,

Use the COPY INTO command to load data into OneLake, you have several flexible options depending on your workflow. You can run T-SQL directly using the SQL Query Editor in Microsoft Fabric, which is ideal for Lakehouse or Warehouse ingestion. Alternatively, tools like Azure Data Studio or SQL Server Management Studio (SSMS) can connect to your Fabric Warehouse especially if TDS endpoints are enabled allowing you to execute COPY INTO seamlessly. For notebook-driven workflows, Microsoft Fabric Notebooks support SQL cells where you can embed the command as part of a broader data pipeline. And while Power BI Dataflows Gen2 isn't a direct SQL interface, it complements structured data ingestion into OneLake by integrating well with Lakehouse destinations.

OneLake as a Source for COPY INTO and OPENROWSET (Preview) | Microsoft Fabric Blog | Microsoft Fabri...

We appreciate your engagement and thank you for being an active part of the community.

Best Regards,

Lakshmi.