Skip to main content
Question

Microsft Fabric Lake Houses Integration

  • November 4, 2025
  • 2 replies
  • 56 views
andrewj74
Supporter
Forum|alt.badge.img+7

Hi, I’ve seen this touched on in other posts, but I wanted to ask directly: has anyone had success getting data into a Microsoft Fabric Lakehouse, and what are the best authentication methods?

I think there are potentially options using the Azure Blob Storage connector to push CSV files in, and possibly using the Fabric API as well. Before I go down the governance route and request SAS tokens or API keys, I’d like to hear about others’ experiences to make sure what I’m asking for is actually going to work.

I have a few data rescue use cases where I need to scrape large volumes of documents, structure the outputs using FME, and then write the data to a Lakehouse so the business can use it for reporting.

I’ve managed to get data out of Lakehouses using the SQL endpoint with a SQL Database Reader, since it has Entra ID authentication integrated.

Any insights apperciated.

 

 im using FME 2024

danilo_fme

2 replies

desiree_at_safe
Safer
Forum|alt.badge.img+16

Hi ​@andrewj74! Thanks for your question! The Microsoft Fabric Lakehouse didn’t get much love in the past, but I’m happy to say we’ll have official support in FME 2025.2, set to be released some time this coming fall/winter!
A few things that I’m aware of that you are able to do are:

  1. Read from and write to SQL Server on Fabric using the Azure SQL Database (JDBC MSSQL) reader/writer
  2. Read Warehouse data using the Azure SQL Database (JDBC MSSQL) reader.
  3. Read data from Microsoft Fabric’s OneLake SQL Database and Lakehouse data using the new Delta Lake reader.
  4. Entra ID authentication support including MFA and Service Principals.

I’d really encourage you to test out our current Beta and see how it might fit into your workflow.
Also if you have any thoughts, please continue to share it on the community! Whether it be through the IDEAS portal, the Early Adopter Program, or just here in a regular thread 🙂 our team is always eager to hear ways to improve your experience.

Happy FME-ing!
andrewj74
andrewj74
Supporter
Forum|alt.badge.img+7
  • andrewj74Supporter
  • Author
  • Supporter
  • November 10, 2025

Thanks for the info and that is really good to hear!! We are due an FME upgrade so i will see if i can hold them off until this release!! Thanks Again

desiree_at_safe

Community Stats

32,154
Posts
122,043
Replies
39,812
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.