Power Platform Community Forum Thread Details

Powerplatform dataflow manual refresh is working. However, when I try to set the scheduled refresh, I am encountering the below error:

Unhandled HTTP Request Exception. Status Code: 400. Reason: . Response Text: "Forbidden::0x80040220::XrmODataClient_PrivilegeDenied".

Stack:

Error: Unhandled HTTP Request Exception. Status Code: 400. Reason: . Response Text: "Forbidden::0x80040220::XrmODataClient_PrivilegeDenied".
at https://us.prod.powerquery.microsoft.com/DataflowsApp/scripts/app.ae17c943243d65ee1b21.bundle.js:8:204142
at async Q3 (https://us.prod.powerquery.microsoft.com/DataflowsApp/scripts/app.ae17c943243d65ee1b21.bundle.js:8:203376)
at async Object.onCommit (https://us.prod.powerquery.microsoft.com/DataflowsApp/scripts/app.ae17c943243d65ee1b21.bundle.js:8:203269)
at async m.value.startFlow.a (https://us.prod.powerquery.microsoft.com/DataflowsApp/scripts/app.ae17c943243d65ee1b21.bundle.js:8:139596)
at async kN.onCommitCurrentFlow (https://us.prod.powerquery.microsoft.com/DataflowsApp/scripts/app.ae17c943243d65ee1b21.bundle.js:8:51325)

The Power M Query displayed in the mashup script is totally irrelevant to the dataflow that I am trying to set scheduled refresh to. Any help?

Categories:

Power Query

The error message "Forbidden::0x80040220::XrmODataClient_PrivilegeDenied" suggests that you lack the necessary permissions to schedule a refresh for the dataflow in Power Platform. However, since the manual refresh is working, the issue is likely related to background processes and automation privileges.

Troubleshooting & Resolution Steps

1. Ensure You Have the Right Security Role

To schedule a refresh, you need sufficient Dataverse permissions. Check your security role in Power Platform Admin Center:

Go to Power Platform Admin Center (admin.powerplatform.microsoft.com).
Navigate to Environments > Select your environment.
Click Settings > Users + permissions > Users.
Find your user account and check your assigned security roles.

✅ Ensure you have one of these roles:

System Administrator (Full access)
Dataflow Administrator (Can configure scheduled refresh)
Environment Maker (May work but lacks some privileges)

If you don’t have these roles, ask an admin to grant you the System Administrator or Dataflow Administrator role.

2. Verify Dataflow Ownership

Open Power Apps (https://make.powerapps.com).
Go to Dataflows.
Select your dataflow and check if you are the owner.
If you are not the owner, request ownership or work with an admin to update it.

✅ Solution: Try reassigning the dataflow owner to your account.

3. Check Dataverse Table Permissions

Since Power Platform Dataflows store data in Dataverse, you may need additional permissions for background processes:

Navigate to Power Platform Admin Center.
Go to Security Roles.
Select your assigned role (e.g., Environment Maker).
Under Core Records, ensure you have Read, Write, Append, and Append To access for Dataflows and Dataverse tables.

✅ Solution: Assign full privileges to Dataverse tables related to the dataflow.

4. Enable Background Dataflow Processing

Navigate to Power Apps (https://make.powerapps.com).
Go to Dataflows > Select your Dataflow.
Click Edit and check the refresh settings.
If there’s an option for "Enable background refresh", enable it.
Try setting up the scheduled refresh again.

✅ Solution: Ensure background processing is enabled.

5. Recreate the Dataflow with a New Owner

If nothing else works, try this:

Duplicate the Dataflow:
- Go to Dataflows.
- Select your dataflow > Export JSON.
- Create a new dataflow using this JSON.
Set Up the Schedule in the New Dataflow.
Test Scheduled Refresh.

✅ Solution: Creating a fresh dataflow may fix ownership and permission issues.

Final Steps

✅ Check Security Roles (ensure you are a System Administrator or Dataflow Administrator).
✅ Verify Dataflow Ownership.
✅ Ensure Dataverse permissions for background refresh.
✅ Enable Background Dataflow Processing.
✅ Try Duplicating the Dataflow.