Error occurred while refreshing

Hi Anonymous 

If the Memberships table is the only one having problems despite similar changes being made to others tables, here are a few steps to investigate:

• Even if data loads fine in Power Query, ensure the type changes are compatible with the data model. For example, converting numeric columns to text might work in some contexts but could cause issues in calculations or relationships.
• If any calculated columns or measures rely on the Memberships table, they might break due to type changes or data format mismatches.
• After changing column types, ensure there are no invalid or unexpected values in the Memberships table that could trigger errors during refresh.

if the issue still persists request to raise a Support Ticket.

Hope it helps !
Regards,
v-aatheeque

If this post was helpful, please consider marking Accept as solution to assist other members in finding it more easily.

If you continue to face issues, feel free to reach out to us for further assistance!