Forum Discussion
Refreshes failing
I am trying to fix a synchronization error that is preventing a dataset from refreshing. When I try to run the refresh it shows errors, either that a column is missing in one table, so I added the missing columns. Now I'm getting an error below, but how do I identify where the mismatch is? I don't see an error in PowerQuery.
Data source error: The following system error occurred: Type mismatch. Table: TOPEL.
Cluster URI: WABI-US-EAST2-redirect.analysis.windows.net
Activity ID: c39d0b23-6970-435d-bf1f-00c298af3f4a
Request ID: afd678f8-bf58-7d4f-2b95-60509175cdad
Time: 2024-09-16 19:12:59Z
Hi aspitalnick
It appears to me that your data source is changing and that is why the refresh is failing. Could you check and make sure that the data you are loading does not have any new columns or that columns get removed as this will break the refresh process.
4 Replies
- GilbertQ
Super User
Hi aspitalnick
It appears to me that your data source is changing and that is why the refresh is failing. Could you check and make sure that the data you are loading does not have any new columns or that columns get removed as this will break the refresh process.
You solved my problem also, thank you so much.
Hi,aspitalnick .I am glad to help you.
Has your problem been solved?
If you have found suitable solutions, please share them as it will help more users with similar problems.
Or you can mark the valid suggestions provided by other users as solutions.
Thank you very much for your understanding and support of Power BI.I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
mohdmohideen200Helper I
"Data source error:" is a label.
