How do I resolve a azure data factory Rest call failed with client error, status code 403 Forbidden, please check your activity settings

Question

Trying to retrieve POWERBi usage metrics using Azure data Factory and receiving the folowwing error -> Failure happened on 'Source' side. ErrorCode=RestCallFailedWithClientError,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Rest call failed with client error, status code 403 Forbidden, please check your activity settings.

Request URL: https://api.powerbi.com/v1.0/myorg/admin/activityevents?startDateTime=2024-06-06T00:00:00.000Z&endDateTime=2024-06-06T23:59:00.000Z.

Response: ,Source=Microsoft.DataTransfer.ClientLibrary,'

Any one come across this. FYI my linked service connections test succesfully

Answer 1

from the error message, your application does not have the necessary permissions to access the requested resource,

from the app registrations, you need to provide the correct permissions to the power BI service to resolve the issue.

https://learn.microsoft.com/en-us/power-bi/developer/embedded/embed-service-principal#enable-access-to-the-power-bi-api