How do I solve array data type not supported for Lakehouse?

arpost, Thanks for reaching MS Fabric community support

In Microsoft Fabric's SQL Analytics Endpoint, complex data types like ARRAY are not currently supported for direct querying. The only options available right now are:

• Convert the ARRAY column to STRING: You can store the array as a JSON-formatted string and later parse it in Power BI or another tool.

• Since Fabric Lakehouse supports ARRAY, you can still work with it using Spark notebooks instead of SQL Analytics Endpoint.

please refer to below documentation for more info:

https://learn.microsoft.com/en-us/fabric/data-warehouse/data-types#unsupported-data-types

Microsoft's official support for such functionality is limited we recommend to submit your ideas here to Fabric team: https://ideas.fabric.microsoft.com/ideas/search-ideas/

Thanks,

Prashanth Are

MS Fabric community support.

Did I answer your question? Mark my post as a solution, this will help others!

If my response(s) assisted you in any way, don't forget to drop me a "Kudos"