Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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])
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
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.
Does it work to add a custom column with Binary.ToText([BinaryColumn])?
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.