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
Subscribe to:
Post Comments (Atom)
Power BI APP - Delete or Unpublish
UNPUBLISH DELETE
-
There are two points to be evaluated: 1. If you want to discard the errors In this case, just run: #"Removed errors" = Table.Re...
-
====================================================== CSV: let Source = SharePoint.Files("https://site", [ApiVersion = 15]), ...
-
Code for creating a table Dim_Calendar Refresh Path let Source = "C:\Temp\datasets\board\csv\__20200210_120926_.ARCHIVE" ...
No comments:
Post a Comment