Thursday, July 23, 2020

Power Query - Using Combine of Dataflows




let
    Source = PowerBI.Dataflows(null),
    Source01 = PowerBI.Dataflows(null),
    Source02 = PowerBI.Dataflows(null),
    Source03 = PowerBI.Dataflows(null),

    Step00 = Source{[workspaceId="workspaceIdXPTO"]}[Data], //Vendas_PRD
    StepT0 = Step00{[dataflowId="dataflowIdXPTOA"]}[Data], //Diario
    StepT0a = StepT0{[entity="FAT_SAP_Vendas_Diario"]}[Data],

    Step01 = Source01{[workspaceId="workspaceIdXPTO"]}[Data], //Vendas_PRD
    StepT1 = Step01{[dataflowId=DF2018]}[Data], //dataflowIdXPTOB
    StepT1a = StepT1{[entity="FAT_SAP_Vendas_2018"]}[Data],

    Step02 = Source02{[workspaceId="workspaceIdXPTO"]}[Data], //Vendas_PRD
    StepT2 = Step02{[dataflowId=DF2019]}[Data], //dataflowIdXPTOC
    StepT2a = StepT2{[entity="FAT_SAP_Vendas_2019"]}[Data],

    Step03 = Source03{[workspaceId="workspaceIdXPTO"]}[Data], //Vendas_PRD
    StepT3 = Step01{[dataflowId=DF2020]}[Data], //dataflowIdXPTOD
    StepT3a = StepT3{[entity="FAT_SAP_Vendas_2020"]}[Data],

    StepJoin = Table.Combine({StepT0a , StepT1a, StepT2a, StepT3a})
in
    StepJoin

No comments:

Post a Comment

Power BI APP - Delete or Unpublish

 UNPUBLISH DELETE