Forum Discussion

mireles's avatar
mireles
New Contributor III
1 month ago
Solved

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
    1 month 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

     

     

LeeB's avatar
LeeB
Contributor III
1 month 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