Transformation help please?

Hi Everyone, I have a worksheet with 50k+ rows and would like to create a lineage using power query but I can't seem to get it right. Can someone please help? Thank you so much in advance! ...

Need Help

MT_1909

New Member

3 years ago

Hi wdx223_Daniel,

Thank you so much for the code, I've tested it and it worked, perfectly what I'm looking for.

I would like to test the code using my xls file but am having trouble in how to ...

replace this ...

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("fZDBCoAgDIbfxXOXnCheqzfIm0gUdLM69f5li20dDATHvv8bYzGqcRq6VjX3H+Ylr1j2Rz63vdThxYFxIJya+B9AXzPWAmvyqwH0DWMjsCG/GkDfMrYC28e/G59XeuUmwDcBcRN4ZwLPBDETaKdqAH3H2AnsyK8G0PeMvcBepXQB", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Source DB" = _t, #"Source Table" = _t, #"Source Column" = _t, #"Target DB" = _t, #"Target Table" = _t, #"Target Column" = _t]),

to point to an xls file ...

let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content]
in
Source

Thank you so much again and am looking forward to your response 🙂