Forum Discussion
Power BI API Connectivity in Azure Data Factory
Hi sbrahmbhatt ,
Thank you for reaching out to the Microsoft Fabric Community. This is often caused by permission or endpoint issues with Power BI Admin APIs.
403 indicates that the account or service principal is not a Power BI Admin, or Admin APIs are not enabled in tenant settings. 404 means the endpoint is incorrect (the URL you shared with mlgcompanies doesn’t appear valid it should be /myorg/admin/...).
If you’re using ADF, make sure you’re using OAuth2 with an App Registration, and that the service principal has the necessary permissions and is allowed in Power BI tenant settings. It’s a good idea to test the API in Postman first to verify access before using Copy Data.
I hope this clarifies the situation. If I’ve misunderstood any part of your situation, please let us know.
Thanks for your reply. We are still receiving the error.
As far as the 404 error, yes that's correct about the company name in the URL. I did update the URL to reflect 'myorg' instead of the actual company name previously but still receiving the error.
Regarding the 403 error, the Application that was setup as the Service Principal has been added as a Power BI Admin. Admin status also has been granted. Auditlog.Read.All or Activitylog.Read.All however is not showing up under the Application's API Permissions. If one of those are required, that may be the issue.
Yes, we're using ADF and as for the Authentication Type in we are using Service Principal, not OAuth 2.0 Client Credential. Do you recommend we try that? If so what do you recommend should be used as 'Token Endpoint'?
Thanks again for your reply!