Forum Discussion
How to open a structured impala table in PBI?
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. 😉
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.
1 Reply
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.