Forum Discussion
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-aatheequeIf 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!
Then use that DSN in your Power BI Desktop ODBC connection, instead of trying the DSN-less connection.
I tested to refersh the simple modle without any measures and calculations. It was successfully refreshing.
Someone told me to see if the error is because you changed column types in memberships table. I checked in power query that maybe it is creating issue while loading from the source. But there was no issue, data was loading correctly.
I have changed the column types in other tables as well, but they are loading perfectly. only this membership table is showing issues.
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-aatheequeIf 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!
There was one calculated column with the type:any which was suppose to be whole number. That column was creating the issue.
Hi Anonymous ,
We haven’t heard back from you regarding our previous response and wanted to check if your issue has been resolved.
If it has, please consider clicking “Accept Answer” and “Yes” if you found the response helpful.
If you still have any questions or need further assistance, feel free to let us know — we're happy to help!Thank you!