Forum Discussion
loading data get error massage , what should i do ?
You can click on the 'error' and it will let you know what value is causing the issue.
It is likely that the data type is not compatible with how that field is set up or it could be a #div error or #N/A.
You may need to clean up the source data.
Anonymous
On Power Query Editor go to Home tab and remove errors.
See image below
2 Replies
- Daviejoe
Memorable Member
You can click on the 'error' and it will let you know what value is causing the issue.
It is likely that the data type is not compatible with how that field is set up or it could be a #div error or #N/A.
You may need to clean up the source data.
- themistoklis
Community Champion
Anonymous
On Power Query Editor go to Home tab and remove errors.
See image below