Forum Discussion
Solved
Oracle database type varray not supported
Hello, I'm trying to pull data in from an Oracle database and I'm running into errors like "DataSource.Error: Values of column 'COLUMN' have type 'type_number_varray' which is not supported" and ...
You will have to convert (or exclude) these columns as part of your custom SQL query.
Hi oktober42 ,
You can try to turn off automatic detection of data types. When you turn off this function, when you import data, all data will only be displayed in text format, you need to manually detect the data type or manually modify the data type.
Data types in Power Query - Power Query | Microsoft Docs
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.
Thanks for the reply! Alas, it was a structured source, so this didn't fix my issue.