Forum Discussion
Integer array read as text by power BI, converting the type does not work
Reading data from a PostgreSQL database in power BI. One of the columns in my data is an integer array; so each cell has an array data. When Power BI reads it, it shows it as text. Furthermore, when ...
Ahmedx
Super User
Super UserWhat do you want to do next with it?
= Text.Split(
Text.Select([posttimea rray],{"0".."9",","}),",") // so you get a list
------
List.Sum(
List.Transform(
Text.Split(
Text.Select([posttimea rray],{"0".."9",","}),","), Number.From)) // so you get the sum