Data flow created with JSON source

[maha_electro]

HI All,

i got access to data flow created by other region. when i refered to that data flow, i am not able see the Source of that dataflow.

when i see the M query, it shows JSON format. below is the screen shot for your ref. please help me out for this, where they are getting this data in data flow.

Thanks in advance.

Regards,

Mahavishnu

[maha_electro]

Hi Sai,

Please find below query for your kind ref.

Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("PY1BCsIwEEWvMmSlUCFpLbFL3RQLQqGCSOliIKENlhlJo+fxLJ7MaKmbP4/P503biqbcZFIqqUUi/tBY7DFYaBz1eGdvIZaFhAuzGZHMBPunpYeF33gZfbmMoTNdKCW6ZLGnOp3tMyz2IwXrCYNjwhFWFQ/sYQ2NITgMJg7rkQPkOVQYn0Jt/eTQRzrbG/HIvXu/fjpCF+/pGkPt1FZK0XUf", BinaryEncoding.Base64), Compression.Deflate)), {"CustomerKey","Customer Number","Customer","Street","City","Country Key","Postal Code"})

Regards,

C.Mahavishnu

[SaiTejaTalasila]

Hi @maha_electro ,

When you input data manually using Enter Data from the Power BI tab, the query it generates looks like that first line. Basically, it takes the information you put in and converts it into a compressed form that isn't human-readable to save space. That first line is decompressing it back into a table format.

You can refer this for more details -

https://community.fabric.microsoft.com/t5/Desktop/What-is-Json-Document-Binary-Decompress/td-p/27255...

[SaiTejaTalasila]

Hi @maha_electro ,

Please open advance editor and share that query.

Thanks,

Sai Teja