Solved: How to open a structured impala table in PBI?

searnold · ‎01-11-2023

Hallo All,

The following impala table (spi_test) contains simple columns, structures and arrays at the same time:

After opening this table Power Query Editor shows only the simple columns. Structures and arrays are not visible:

It is not possible to drill down in spi_test table in navigation windows :

Is it possible to make visible and handling structs and arrays inside a structured impala table with PBI?

Many thanks for your help. 😉

v-jingzhang · ‎01-13-2023

Hi @searnold

You can find all supported data types in Power Query from M Language types - PowerQuery M. Power Query doesn't support structs or arrays and it doesn't have functions to deal with these data types. So I'm afraid it is not possible to make visible or handle structs and arrays in Power BI.

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

View solution in original post

v-jingzhang · ‎01-13-2023

Hi @searnold

You can find all supported data types in Power Query from M Language types - PowerQuery M. Power Query doesn't support structs or arrays and it doesn't have functions to deal with these data types. So I'm afraid it is not possible to make visible or handle structs and arrays in Power BI.

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.