loading data get error massage , what should i do ?

[Paulyeo11]

[Daviejoe · Accepted solution]

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 · Accepted solution]

@Paulyeo11 

On Power Query Editor go to Home tab and remove errors.

See image below

[Daviejoe · Accepted solution]

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.