Forum Discussion

Aniketparab1234's avatar
Aniketparab1234
Regular Visitor
1 year ago
Solved

Getting error 403 Forbidden: while using Default.UpdateDatasources API

I’m trying to use the Default.UpdateDatasources API, but I’m encountering a 404 Forbidden error. After investigating, I understand that to resolve this issue, I need to grant the following applicati...
  • v-achippa's avatar
    v-achippa
    1 year ago

    Hi Aniketparab1234,

     

    Thank you for the response and confirming that the issue is resolved now. I request you to please accept the post as Accept as Solution so that other members who has similar issue will find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

     

    Thanks and regards,

    Anjan Kumar Chippa

grazitti_sapna's avatar
grazitti_sapna
Super User
1 year ago

Hi Aniketparab1234 

Resolution Steps:
1. Ensure the Correct API is Added
Power BI API permissions added under "Application permissions" should be granted.

2. Grant Admin Consent
After adding the required application permissions:

  • Click "Grant admin consent for <Your Tenant>" to approve them for your tenant.

This is mandatory for application permissions to take effect.

 

3.Use a Service Principal (not a user)
Make sure you're using a service principal and Service principal should be enabled in Power BI Admin Portal.

🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!

  • Aniketparab1234's avatar
    Aniketparab1234
    Regular Visitor
    1 year ago

    Hi grazitti_sapna 

     

    Thank you for your feedback.

     

    Actually,The tenant setting “Service principals can use Fabric APIs” has already been enabled from the PowerBI Admin portal.

     

    And when I go to add permission under Application Type, it only shows Tenant permissions, not Report or Workspace permissions which are required to use update dataset API.

     

    • Swetha__Balusam's avatar
      Swetha__Balusam
      New Member
      1 year ago

      Hi, I am also facing the same issue. Have you found any solution?

      • Aniketparab1234's avatar
        Aniketparab1234
        Regular Visitor
        1 year ago

        Yes. Permissions were correct.

        I made changes in body. 
        {
        "updateDetails": [
        {
        "datasourceSelector": {
        "datasourceType": "Oracle",
        "connectionDetails": {
        "server": "current server"
        }
        },
        "gatewayId": "target gateway id",
        "datasourceId": "target datasource ID",
        "connectionDetails": {
        "server": "target server"
        }
        }
        ]
        }

        Customize the body this way and try it