PowerQuery and Oracle Raw column

[Anonymous]

Trying to create a dataflow against an oracle db where the PKs are guids stored as Raw.  PowerQuery thinks that it is a binary and drops the column as complex type.  Cant convert to a different datatype as the option is disabled and just shows binary.

[O_oo_O]

This is kind of dirty, but it does the trick: concat an empty string to the columns that give you trouble as done below.

= Oracle.Database("MYDATABASE", [Query="select t.guid_column || '' from mytable t", CreateNavigationProperties=false])

[v-stephen-msft]

Hi @Anonymous ,

Sorry to disturb you...

But did I answer your question ? Please mark my reply as solution. Thank you very much.

Best Regards,
Stephen Tao

[v-stephen-msft]

Hi @Anonymous ,

If a binary column is in the output of the steps of a query, attempting to refresh the data through a gateway can cause errors. It's recommended that you explicitly remove any binary columns as the last step in your queries.

Reference: Applied steps

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mahoneypat]

Does it work to add a custom column with Binary.ToText([BinaryColumn])?

Pat