Hi,
I am having problems with copying queries on dataflow:
What I am trying to acheive is:
1) On the queries pane, select a query or a group of queries
2) Ctrl + C
3) Ctrl + V either in the same dataflow or in a different dataflow
This works for some queries, but not others (with same source but different steps). When it doesn't work, I get the message "We could not find queries in your clipboard".
Is the option to use the copy and paste shortcut only available to some queries but not others? I know I can copy from advance
An example of a query that does work:
let
Source = OData.Feed("link to sonarQube data", null, [Implementation = "2.0"]),
#"Navigation 1" = Source{[Name = "teams", Signature = "table"]}[Data],
#"Remove columns" = Table.RemoveColumns(#"Navigation 1", Table.ColumnsOfType(#"Navigation 1", {type table, type record, type list, type nullable binary, type binary, type function})),
#"Added custom" = Table.AddColumn(#"Remove columns", "Portfolio", each "Baggage Management"),
#"Transform columns" = Table.TransformColumnTypes(#"Added custom", {{"Portfolio", type text}}),
#"Replace errors" = Table.ReplaceErrorValues(#"Transform columns", {{"Portfolio", null}})
in
#"Replace errors"
An example of a query that didn't work:
let
Source = OData.Feed("link to sonarQube data", null, [Implementation = "2.0"]),
defects_table = Source{[Name = "defects", Signature = "table"]}[Data],
#"Removed other columns" = Table.SelectColumns(defects_table, {"creation_time", "id", "servicenow_id_udf", "area_path_ado_udf", "iteration_ado_udf", "has_attachments", "migrated_closing_date_udf", "repro_steps_udf", "committed_comments_udf", "rca_udf", "has_comments", "migrated_creation_dat_udf", "name", "target_fix_date_udf", "description", "closed_on", "committed_closure_dat_udf", "ado_id_udf", "parent", "release", "phase", "user_tags", "defect_origin_udf", "attachments", "linked_items1", "defect_source_udf", "responsible_team_udf", "run", "defect_type", "test", "author", "application_modules", "test_type_udf", "severity", "requirements"}),
#"Added custom" = Table.AddColumn(#"Removed other columns", "Portfolio", each "Communications & Data Exchange"),
#"Transform columns" = Table.TransformColumnTypes(#"Added custom", {{"Portfolio", type text}}),
#"Replace errors" = Table.ReplaceErrorValues(#"Transform columns", {{"Portfolio", null}}),
#"Remove columns" = Table.RemoveColumns(#"Replace errors", Table.ColumnsOfType(#"Replace errors", {type table, type record, type list, type nullable binary, type binary, type function}))
in
#"Remove columns"
Thank you!
