Forum Discussion

mireles's avatar
mireles
New Contributor III
10 hours ago

Connect MS Fabric Lakehouse?

Hi all, I'm currently exploring ways to extract data from a Microsoft Fabric Lakehouse into OneStream. The obvious way would be to connect to the SQL endpoint just like any other DB. In this case...
Data Integration
Import
LeeB's avatar
LeeB
Contributor III
9 hours ago

Hi,

We've done this recently via a SQL Endpoint to Fabric.  The client created an Azure Service Principal Account with access to the relevant views and tables and we used those details in the Connection String when setting up the DB Connection in OneStream.

Other clients have had a preference for Web API connections to Fabric.

Regards,
Lee