Azure Monitor Rest API Authentication Data Factory

Samco23 — Sun, 14 Jul 2024 13:42:59 GMT

Hi All,

I am calling the same API in Power BI desktop and Fabric Data Factory. It works ok with Power BI desktop (and service) but I am facing an authentication error in Data Factory. In desktop and service it is Oauth2but data factory does not have this option so I used basic authentication. I am new to working with APIs and API authentication.

Is there a way to use the same authentication I am using for power bi desktop (just my org username) with data factory? Or I have to create a Service Principal for this API?

API: https://management.azure.com/subscriptions/{subscriptionID}/resourceGroups/{resourceGroupID}/providers/microsoft.insights/metrics?timespan=2024-04-01T22:20:00.000Z/2024-06-30T23:45:00.000Z&interval=PT30M&metricnames=Percentage CPU&top=100&aggregation=average&api-version=2023-10-01&region={region}&metricNamespace=microsoft.compute/virtualmachines&$filter=Microsoft.ResourceId eq '*'"

Data Factory Error:

Rest call failed with client error, status code 401 Unauthorized, please check your activity settings.
Response: {"error":{"code":"AuthenticationFailedInvalidHeader","message":"Authentication failed. The 'Authorization' header is provided in an invalid format."}}

I tried getting a token by loging in here but I am getting an error:

https://login.microsoftonline.com/common/oauth2/authorize returns error: The request body must contain the following parameter: 'client_id'

Do I have to register theAPP like below or there is an easier way?

Thanks,
Sam

Re: Azure Monitor Rest API Authentication Data Factory

Anonymous — Mon, 15 Jul 2024 06:21:34 GMT

Hi Samco23 ,

I think you firstly need to Navigate to the Azure portal -> Subscription -> add your service principal as a Contributor/Owner role in the subscription like below.

Then I think in the linked service, configure it like below, fix them with the values.

Finally I test the linked service with a copy activity, it works fine.

You can also look at this document for a further study: Register a Microsoft Entra app and create a service principal - Microsoft identity platform | Microsoft Learn

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

topic Azure Monitor Rest API Authentication Data Factory in Pipelines

Azure Monitor Rest API Authentication Data Factory

Re: Azure Monitor Rest API Authentication Data Factory