Power Query create list from database column

[NathanF]

I am aware of the capability to enter "= {1..15}" in Power Query to generate a list of 1 through 15. I am trying to find a way to have that value in a database column (i.e., store "1..15" or "{1..15}" in a database) and have PQ read that result and generate the list 1 through 15. I have tried multiple iterations of this and cannot get anything to work. Any help or examples would be appreciated!

Thank you,
Nathan

 

[Norie]

Nathan

You could split the values into 2 columns, let's say Start and Finish, and then add a new column with a custom function like this.

={[Start]..[Finish]}

You would end up with lists in the new column and you could expand those lists however you want, e.g. into rows.

 

[sandy666]

Power Query will not generate the list itself by fetching a field with the {1..15} function or two columns as Norie mentioned - each time a user action is required or a predefined M-code with such action