Show Data Lineage From SSIS > SSAS > Report

%3CLINGO-SUB%20id%3D%22lingo-sub-2894274%22%20slang%3D%22en-US%22%3EShow%20Data%20Lineage%20From%20SSIS%20%26gt%3B%20SSAS%20%26gt%3B%20Report%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2894274%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Good%20Day%2C%3C%2FP%3E%3CP%3ENeed%20your%20help.%3C%2FP%3E%3CP%3EOur%20Data%20is%20Similar%20to%20this%20example%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22amarie07_2-1635404190148.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F320746i255D6DB47A0F29B0%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22amarie07_2-1635404190148.png%22%20alt%3D%22amarie07_2-1635404190148.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20have%20Three%20Schemas%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B-%20Two%20Schemas%20is%20for%20Data%20Source%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B-%20Last%20Schema%20is%20for%20the%20Report%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%26gt%3B%20We%20have%20Two%20Table%20in%20our%20Last%20Schema%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B-%20The%20First%20one%20Consist%20with%20Scripts%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B-%20The%20Second%20is%20the%20Combined%20Result%20of%20all%20Scripts%20from%20the%20First%20Table%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOur%20Boss%20wants%20us%20to%20track%20the%20Lineage%2FFlow%20of%20the%20%22Combine%22%20Table%20based%20on%20the%20Scripts%20we%20created.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20this%20possible%20to%20create%20a%20Lineage%20for%20this%20not%20using%20SQL%20Flow%2C%3C%2FP%3E%3CP%3Eand%20can%20create%20a%20dashboard%20for%20this%20in%20Power%20BI%20so%20that%20we%20can%20present%20it%20to%20them%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOur%20desired%20output%20will%20be%20like%20this%3A%3C%2FP%3E%3CP%3E(if%20we%20manually%20create%20a%20script%20in%20SQL%20Flow)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22amarie07_0-1635405090787.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F320748i3B385296C03A2F7A%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22amarie07_0-1635405090787.png%22%20alt%3D%22amarie07_0-1635405090787.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20a%20lot%20in%20advance.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2894274%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAnalysis%20Services%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EData%20Warehouse%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EReporting%20Services%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Hi Good Day,

Need your help.

Our Data is Similar to this example:

amarie07_2-1635404190148.png

 

We have Three Schemas

   - Two Schemas is for Data Source

   - Last Schema is for the Report

       > We have Two Table in our Last Schema

             - The First one Consist with Scripts

             - The Second is the Combined Result of all Scripts from the First Table

 

Our Boss wants us to track the Lineage/Flow of the "Combine" Table based on the Scripts we created.

 

Is this possible to create a Lineage for this not using SQL Flow,

and can create a dashboard for this in Power BI connected with the server so that we can present it to them and if there are changes we can track it right away?

 

Our desired output will be like this:

(if we manually create a script in SQL Flow)

 

amarie07_0-1635405090787.png

 

Thanks a lot in advance.

 

 

 

0 Replies