Dataflow Gen 2 Error:MashupException.Error:Expression.Error: We cannot convert a value of type List

Hi Thyagarajulu99 ,

The error message indicates that Dataflow Gen2 is trying to convert a List to a Table, which is an invalid operation. You can use the Table.FromList function to correctly convert a List to a Table.

let
    MyList = {1, 2, 3, 4, 5},
    MyTable = Table.FromList(MyList, Splitter.SplitByNothing(), null, null, ExtraValues.Error)
in
    MyTable

For more details, you can refer to below document:

Table.FromList - PowerQuery M | Microsoft Learn

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.