There was a problem refreshing the dataflow, the dataflow definition contained errors. Please fix the problem and try again. Additional information: Unexpected exception, Message: <pi>Expression.Error: The column '' of the table wasn't found.</pi>

[Syndicate_Admin]

Hello,

I keep getting the error:

There was a problem refreshing the dataflow, the dataflow definition contained errors. Please fix the problem and try again. Additional information: Unexpected exception, Message: Expression.Error: The column 'Data de Nascimento (formato dd/mm/aaaa)' of the table wasn't found.. (Request ID: c7973e3f-7).

Upon refreshing a dataflow.

There's nothing wrong with the dataflow. If I simply copy/paste the Power Query code into Power BI desktop it runs without issues!!!

[Anonymous]

Hi @webportal ,

To resolve this issue, please follow these steps:

1. Verify the column name: Double-check the column name 'Data de Nascimento (formato dd/mm/aaaa)' in your dataflow definition. Make sure it matches the column name in the source data.

2. Check the data source: Ensure that the data source you are using for the dataflow contains the column 'Data de Nascimento (formato dd/mm/aaaa)'. If the column is missing in the source data, you will need to add it or modify the data source accordingly.

3. Refresh the dataflow: After verifying the column name and ensuring it exists in the data source, try refreshing the dataflow again.

This should resolve the issue if the column is now found during the refresh process.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.