Unanswered

Dataflow Not Showing Correct Columns to Map

(0) Share

Report

Posted on by Community Power Pla...

I have a dataflow that is using a SQL Server query as it's source. After I do some transformations in Power Query the output of the dataflow looks like this:

When I click on Next to map these columns to an existing Dataverse table that is the target table, the column names that are showing above do not show up as options in my Source list to map to the table. The columns that are showing are the columns that are available from the original query (prior to when I apply all of my transformation steps). Is this a bug or what am I missing?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Prakash4691 1,332 on at

Like (1)

Report

@Anonymous ,

No, it is not a bug.

Check in applied steps of power query, whether the Source stays in step 1.

In your case it looks like that might have been modified to include it at end or after transformation steps.

Make sure Source always stays at top.

If it answers your question, kindly give kudo and mark it as solution.

Regards,
Prakash

Was this reply helpful? Yes No
Verified answer

Community Power Pla... on at

Like (0)

Report

UPDATE: I figured it out. The "in" part of my applied steps was somehow referencing one of the first few steps instead of the last step.  😵

Hi Prakash .. thank you for the response. I don't believe that is the issue.

Here is the M code from the Advanced Editor for reference....

let
  Source = Sql.Database("WEEAPP81P", "sap_data", [Query = "SELECT * FROM FIP79#(lf)WHERE#(lf)PERIOD > 202012 AND (SUBSTRING(WBS_Element,1,4)='C.EN' OR SUBSTRING(WBS_Element,1,4)='C.SP')#(lf)", CreateNavigationProperties = false]),
  #"Added custom" = Table.AddColumn(Source, "FY_MONTH", each Number.FromText(Text.End(Number.ToText([PERIOD]), 2))),
  #"Changed column type" = Table.TransformColumnTypes(#"Added custom", {{"FY_MONTH", Int64.Type}}),
  #"Added custom1" = Table.AddColumn(#"Changed column type", "FY_YEAR", each Number.FromText(Text.Start(Number.ToText([PERIOD]), 4))),
  #"Changed column type 1" = Table.TransformColumnTypes(#"Added custom1", {{"FY_YEAR", type text}}),
  #"Removed columns" = Table.RemoveColumns(#"Changed column type 1", {"STHRS", "OTHRS", "Company_Code"}),
  #"Inserted month" = Table.AddColumn(#"Removed columns", "Month (2)", each Date.Month([Month]), type number),
  #"Renamed columns" = Table.RenameColumns(#"Inserted month", {{"Month (2)", "CY_MONTH"}}),
  #"Inserted year" = Table.AddColumn(#"Renamed columns", "Year", each Date.Year([Month]), type number),
  #"Changed column type 2" = Table.TransformColumnTypes(#"Inserted year", {{"CY_MONTH", Int64.Type}, {"Year", type text}}),
  #"Renamed columns 1" = Table.RenameColumns(#"Changed column type 2", {{"Year", "CY_YEAR"}}),
  #"Removed columns 1" = Table.RemoveColumns(#"Renamed columns 1", {"Month", "Cost_Center_Description", "Cost_Center"}),
  #"Unpivoted columns" = Table.UnpivotOtherColumns(#"Removed columns 1", {"WBS_Element", "WBS_Element_Description", "PERIOD", "FY_MONTH", "FY_YEAR", "CY_MONTH", "CY_YEAR"}, "Attribute", "Value"),
  #"Renamed columns 2" = Table.RenameColumns(#"Unpivoted columns", {{"Attribute", "RESOURCE"}, {"Value", "AMOUNT"}}),
  #"Changed column type 3" = Table.TransformColumnTypes(#"Renamed columns 2", {{"PERIOD", type text}}),
  #"Renamed columns 3" = Table.RenameColumns(#"Changed column type 3", {{"WBS_Element_Description", "WBS DES"}}),
  #"Removed columns 2" = Table.RemoveColumns(#"Renamed columns 3", {"WBS DES"}),
  #"Renamed columns 4" = Table.RenameColumns(#"Removed columns 2", {{"WBS_Element", "WBSE_ID"}}),
  #"Filtered rows" = Table.SelectRows(#"Renamed columns 4", each [AMOUNT] <> 0),
  #"Added custom 1" = Table.AddColumn(#"Filtered rows", "FIN_PLAN_TYPE", each "ACT")
in
  #"Changed column type"  🖕🖕🖕🖕

Was this reply helpful? Yes No