Pipeline Failed: Error Code 20302 User configuration Issue (Dataflow)

[MaryJo]

Hello,

A pipeline that is connected to a data flow started failing after the user who created the pipeline is no longer with the company.  We switched owndership of the pipeline to a current employee and tried running the pipeline. Same failure with Error Code 20302 User configuration issue.  Microsoft.Data.Transfer.Execution.Core.ExecutionException: Refresh Dataflow failed with status:  Unauthorized message:  Unauthorized.  When clicking into the dataflow the error message there is 'An error occurred while communicating with another service, please try again later.  (Request ID:  _________________________).  

One thing to add the pipeline line is built to run a Dataflow Gen2 and when I go into the dataflow and refresh there it runs successfully.  So must be something to do with the pipeline.

This has been running up until the person left and we did take over new ownership and haven't gotten the pipeline to run since then.  Reaching out for feedback.

Thank you

[JoshWarren]

For completeness, we also got this error when dynamically setting the Dataflow Id instead of manually selecting a dataflow from the dropdown list. It turned out that selecting one from the dropdown list was automatically adding

"dataflowType": "DataflowFabric"

to the pipeline JSON (within the object representing the relevent activity), whilst it was missing if using the dynamic options. Manually inserting that field into the "typeProperties" JSON object resolved this issue. Apparently this identifies it as a Gen2 DataFlow (instead of Gen1).

[MaryJo · Accepted solution]

We raised a ticket with Microsoft and the solution was besides changing the 'Owned by' of the pipeline by opening up 'Settings' of the pipeline and selecting 'Take over' button you also have to make a change within the pipeline.  In our case within the dataflow of the pipeline in the properties of the General or Settings tab I modified the text by tweaking the name or adding a description then saved.  This will then change the 'Last Modified By' to the new owner.  Having this two items changed will allow the pipeline to run under the new owner. Previously we only changed the 'Owned by'.  Here is the link for the solution:  Take ownership of Fabric items - Microsoft Fabric | Microsoft Learn

[v-prasare]

Since the user who originally created the pipeline is no longer with the company, you need to ensure that the new owner has the necessary permissions. Check if the new owner’s Azure Active Directory (AAD) account or the service principal (if you're using one) has proper permissions to access the resources involved in the pipeline.

• Go to the Azure portal > Azure Data Factory > Access Control (IAM) and make sure the new owner has at least the Contributor role or appropriate permissions for all the resources the pipeline accesses.

[MaryJo]

Thank you for your input.  I did check the security and the team has contributor role, which is the same as the previous owner.  

[v-prasare]

Hi @MaryJo,

In this scenario i suggest you to raise a support ticket here. so, that they can assit you in addressing the issue you are facing. please follow below link on how to raise a support ticket:

How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

Thanks,

Prashanth

MS Fabric community support

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query