Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Mailchimp integration

I'm trying to connect PowerBi to Mailchimp, followed all the requered steps as mentioned in https://datachant.com/mailchimp-power-bi/ . When it starts collection data it gives me this error. [Validat...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Anonymous ,

    The error message you provided indicates that the column ‘Column1’ of the table wasn’t found. This error is usually caused by a mismatch between the column name in the query and the actual column name in the data source.
    So here are the suggestions:
    Check if the column name is spelled correctly.
    Check if the column exists in the data source.

    If you have already checked the column name and it still doesn’t work, you may want to try the following steps:
    Check if there are some steps in Power Query that may destroy the original data structure.
    Clear the data source cache in Power BI by going to Data Source Settings and clearing all permissions. Then recapture the permission again.

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