Execute a Data Pipeline from onPrem SQL Server using REST API

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