Forum Discussion

sbrahmbhatt's avatar
sbrahmbhatt
Frequent Visitor
5 months ago

Power BI API Connectivity in Azure Data Factory

Trying to connect to corporate Power BI via API (https://api.powerbi.com/v1.0/mlgcompanies/admin/) in ADF however continue to get 404 or 403 error at runtime.   Linked Service is connecting successfu...
Data Pipeline
Lodha_Jaydeep's avatar
Lodha_Jaydeep
Solution Sage
5 months ago

You’re getting 403 / 404 due to a combination of permission and configuration issues:

 

  1. 403 Forbidden (Most Common)
  • Power BI Admin APIs require admin rights
    • User must be Power BI Service Admin or Global Admin
  • If using Service Principal:
    • Enable in Power BI Admin Portal:
      • Allow service principals to use Power BI APIs
      • Allow service principals to use read-only admin APIs
  1. Missing API Permissions

     In Azure App Registration:

  • Add:
    • Tenant.Read.All
    • AuditLog.Read.All
  • Click Grant Admin Consent
  1. 404 Not Found
  • Ensure there are no typos in the URL
  1. ADF Authentication Issue
  • Use OAuth2 (Service Principal) in Linked Service
  • Do not use Anonymous/Basic auth
  • 403 = permission / admin access issue
  • 404 = wrong API endpoint

 

This should resolve the issue if all configurations are set correctly. Let me know if we have help you more. Also, it is a good practice to have it tested in Postman to get the correct response and status.


Hope this helps! If it resolves your issue, please consider marking it as the accepted solution. kudos are really appreciated.

  • sbrahmbhatt's avatar
    sbrahmbhatt
    Frequent Visitor
    4 months ago

    Thank you Jaydeep for the response.   I did look at all of these possible issues on our end.  All permissions are granted, endpoint is correct, and the service prinipal and security group created to allow for access.   One thing that is not appearing on our end is permissions for 'AuditLog.all' or 'ActivityLog.all'.  Neither are showing up as available API permissions from the Application.  Other than that, all has been included.  The linked service works successfully but the ADF job is erroring out when ran.  Any other recommendations?  Thanks.