Refresh Table failed due to invalid character

Question

Hi,

I create with success powerpivot cube. But after fwee days, I can no more refresh one table. I receive error message:

Errors in the high-level relational engine. The following exception occurred while the managed IDataReader interface was being used: '?', hexadecimal value 0x1C, is an invalid character. Line 92054, position 26..

The operation has been cancelled.

This table come from Data Feed List Sharepoint. I think that no new field has been added or modified from the list. 

Any Idee ? Thank's in advance.

Answer 1

I found the error. One column contains invalid character Hexa 0x1C

To find the Sharepoint item in error. I export all items in Excel than copy in convert application like notepad++ plugin Hexa convertor.

Find the item and replace the character.

Hope this could help some one else

Regards,

---

André Gillard