Forum Discussion
DataSource.Error: An error happened while reading data from the provider: 'Unable to translate bytes
Trying to get data from PostgreSQL 8.4 with enconding SQL_ASCII and keeps me giving me this error.
H Tekuii,
It sounds like the issue has related to the data value encoding. which step did this issue appaers? The source step or 'change type' step? If you mean the second one, you can try to use the binary function to manually declare the encoding format to help the power query recognize these values.
Binary functions - PowerQuery M | Microsoft Docs
If you are facing the first one, it means the power query data connector can't get data from these fields with a specific encoding format, you need to transform the encoding format on the database side before getting dat.
Regards,Xiaoxin Sheng
1 Reply
H Tekuii,
It sounds like the issue has related to the data value encoding. which step did this issue appaers? The source step or 'change type' step? If you mean the second one, you can try to use the binary function to manually declare the encoding format to help the power query recognize these values.
Binary functions - PowerQuery M | Microsoft Docs
If you are facing the first one, it means the power query data connector can't get data from these fields with a specific encoding format, you need to transform the encoding format on the database side before getting dat.
Regards,Xiaoxin Sheng