Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
2 years ago

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>

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!!!

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.