Power Query - Error when importing .xlsb workbooks (PQ)

[pinarello]

When I import from an .xlsb, texts are only imported with a length of 255 characters (first attachment). However, if the first data record contains a longer text (second attachment), then this error does not occur.

 

[pinarello]

I have now heard that PQ uses the “Access Database Engine OLEDB” driver for xlsb files. And since there are both text and memo fields in Access, it decides on the basis of the first data records whether text ends up in a text or memo field. In the case of a text field, whose length in Access is only 255, it is automatically truncated within the driver, even if PQ does not recognize this limitation for text fields. MS will therefore have to make a correction and change the code in the driver so that when it is called by PQ, texts always end up in a memeo field, which is then transferred to a text field at the end of PQ.