Push with expression

RuiRomanoMS Is there any way for me to incorporate an expression in a push dataset while using the rest api ?

 

 

I tried this which did not work

 

{
  "name": "SalesMarketing",
  "defaultMode": "Push",
  "tables": [
    {
      "name": "t1",
      "columns": [
        {
          "name": "Column1",
          "dataType": "String"
        }
      ],
      "ASMashupExpression": [
        {
          "expression": "let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText(\"i45WMlSKjQUA\", BinaryEncoding.Base64),Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 =_t]) in Source"
        }
      ]
    }
  ]
}

or
{
  "name": "SalesMarketing",
  "defaultMode": "Push",
  "tables": [
    {
      "name": "t1",
      "columns": [
        {
          "name": "Column1",
          "dataType": "String"
        }
      ],
      "partitions": [
        {
          "name": "t1",
          "mode": "Push",
          "expression": "let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText(\"i45WMlSKjQUA\", BinaryEncoding.Base64),Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t]) in Source"
        }
      ]
    }
  ]
}

 

 

 

// mQuery used

let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlSKjQUA", BinaryEncoding.Base64),Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 =_t]) in Source

 

 Thank you in advance