Forum Discussion

PowerFabricator's avatar
PowerFabricator
Regular Visitor
1 year ago
Solved

Execute a Data Pipeline from onPrem SQL Server using REST API

Hi, I'm having an application using a SQL Server in a private cloud on one hand and a F64 on the other. The Fabric capacity is connected to several source systems gathering data and pushing it into...
governance
security
  • nilendraFabric's avatar
    nilendraFabric
    1 year ago

    Hello PowerFabricator 

     

    As of today , executing Microsoft Fabric Data Pipelines through REST APIs using a Service Principal (SPN) is not fully supported.

     

    Microsoft Fabric does provide REST APIs for executing data pipelines, such as the “Run On Demand Item Job” API. However, these APIs currently do not fully support authentication using Service Principals

    There are certain workarounds which are already discussed in thus forum:

     

    Instead of using an SPN, you can create a service account in Microsoft Entra ID with MFA disabled

     

    I haven't tried this personally but some developers have suggested using middle-tier services like Logic Apps to authenticate users and then make the necessary calls to the Fabric API

    Check this page for support api with SPN

    https://support.fabric.microsoft.com/en-au/blog/announcing-service-principal-support-for-fabric-apis?ft=09-2024:date

     

    hope this helps 

     

    please accept the answer if this is helpful and give kudos

     

     

     

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi PowerFabricator,

Thank you for reaching out in Microsoft Community Forum.

Thank you  nilendraFabric  for the helpful response.

As suggested  nilendraFabric, I hope this information was helpful. Please let me know if you have any further questions or you'd like to discuss this further. If this answers your question, please "Accept as Solution" and give it a 'Kudos' so others can find it easily.

Please continue using Microsoft community forum.

Regards,
Pavan.